DH
Programmer
- Dec 8, 2000
- 168
Is there a way to have a user enter multiple criteria using a enter parameter value dialog box?
For example, in a query I have entered [Enter Criteria Here] in the criteria cell of the query under the state field. This will prompt the user to enter a state before the query runs which will then filter the data by the state entered. This works great when the user is entering only 1 value.
However, I would like the user to be able to enter multiple states, such as "FL" "TX" "OH". Is there a way to prompt to have multiple states entered? or have a form open that has a listing of all 50 states with a check box next to each state where the user simple checks the states they would like included in the query?
Perhaps I am going about this wrong but any suggestions would be greatly appreciated.
Thanks.
For example, in a query I have entered [Enter Criteria Here] in the criteria cell of the query under the state field. This will prompt the user to enter a state before the query runs which will then filter the data by the state entered. This works great when the user is entering only 1 value.
However, I would like the user to be able to enter multiple states, such as "FL" "TX" "OH". Is there a way to prompt to have multiple states entered? or have a form open that has a listing of all 50 states with a check box next to each state where the user simple checks the states they would like included in the query?
Perhaps I am going about this wrong but any suggestions would be greatly appreciated.
Thanks.