I have a form that has 4 data combo boxes. They are being populated via the same SQL. I would like the 2nd combo box to show the filtered results based on the selection made in the 1st combo box.
"Select YourFields from YourDatabase where TestField = " & val(combo1.list(combo1.listindex))
If it's string:
"Select YourFields from YourDatabase where TestField like '" & combo1.list(combo1.listindex) & "'"
________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first
'People who live in windowed environments shouldn't cast pointers.'
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.