I am not sure how to this. I have a table with two columns:
1 AAA
2 ABA
3 AAA
4 BBB
In my form I have two ListBox. In one of the ListBox I display 揂AA, ABA?in a column format. What I am trying to do is: when the user picks on the AAA the second ListBox would display ??and ??in a ListBox format.
What I was thinking to do is to create a query that will filter 慉AA?form it抯 original location and display everything filtered in the second ListBox.
What do you all think. Perhaps you know a better way to do this.
Also, if I decide to do it the way above, how would I go about feeding the 慉AA?into my Query programmatically?
1 AAA
2 ABA
3 AAA
4 BBB
In my form I have two ListBox. In one of the ListBox I display 揂AA, ABA?in a column format. What I am trying to do is: when the user picks on the AAA the second ListBox would display ??and ??in a ListBox format.
What I was thinking to do is to create a query that will filter 慉AA?form it抯 original location and display everything filtered in the second ListBox.
What do you all think. Perhaps you know a better way to do this.
Also, if I decide to do it the way above, how would I go about feeding the 慉AA?into my Query programmatically?