Hi,
Scenario:
I'm working on a database which holds numerous data about a number of clients.
After the data has been entered, I want to be able to use parameters and only return information about those client which meet the parameters.
Progress so far:
All the data is currently in a table.
I have made a query which has three different parameters.
I have created an unbound form to gather data (from the user) and I have tied that form to a report. Everything works fine right now.
Problem:
The problem I'm having is that the form is only able to return information about clients when I use one value for a parameter.
For example, if I want the form to return all clients which reside in ABC city, all I have to do is type in ABC in the text box in the form and the form will return all clients which reside in that city. However when I convert the city textbox to a list box which allows multiselect, the form doesnt return any data.
Ideal solution:
I want to make it so that I can select ABC and DEF in the form and have it return all clients which reside in ABC and DEF.
Notes:
I have been trying this for hours now and cant get it...maybe I'm missing something.
Also, I'm somewhat limited using VB codes, everything Ive created so far, Ive done using Access 07 tools provided in the tabs.
Any help is greatly appreciated and thank you in advance for all your efforts.