
September 23rd, 2003, 12:33 PM
|
|
Registered User
|
|
Join Date: Sep 2003
Posts: 14
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
Editing the value of the Query Criteria programmatically
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 “AAA, ABA” in a column format. What I am trying to do is: when the user picks on the AAA the second ListBox would display “1” and “2” in a ListBox format.
What I was thinking to do is to create a query that will filter ‘AAA’ form it’s 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 ‘AAA’ into my Query programmatically?
|