Dynamic list when creating a new defect
Does anyone know how to create a dynamic lists in TD? What I'm looking to do is if I choose A from the first list then ListX is the second list displayed, or if I chose B from the first list then the second list is ListY. I pulled this code from Merc's knowledge base (see below) but the issue I have with this solution is I have to post the defect first and then I have to move focus off the new defect and the reopen the new defect to get the list I'm looking for.
'Enter code to before openning a new bug form
If Fields("BG_USER_01").Value = "ListA" Then
Fields("BG_USER_02").List = Lists("ListA")
ElseIf Fields ("BG_USER_01").Value = "ListB" Then
Fields("BG_USER_02").List = Lists("ListB")
Fields("BG_USER_02").List = Lists("")
Re: Dynamic list when creating a new defect
Call the sub from fieldchange and moveto. That will fix your problem.