shuittny
asked on
Listbox values and Access Query Analyzer
I created a query in the Access Query Analyzer. What I want to do to is the display the results of the query based on what values the user has selected via a listbox. However I still want to be able to use the query analyzer to create the SQL statement. I know that I need to write some code in order to gather the listbox values but I wanted to know if its possible to create a string variable within the code that allows me to concatenate the value so that I can use that as part of my "WHERE" clause within the Access Query Analyzer?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Here is a screen shot of the sample form.
Filtering-by-Listbox-Selections.jpg
Filtering-by-Listbox-Selections.jpg
Open in new window