Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Enter Parameter Value

Status
Not open for further replies.

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.


 
You can't do this with a query. You can do it with a form, but you'd save yourself an awful lot of time and effort if you just teach your users to use filters. For most simple needs, even beginners can manage the syntax of the criteria (in this case, for example, it would be 'FL' or 'TX' or 'OH').

Filters are more versatile than custom-written selection methods tend to be. And filters are built in, so they're free!

If you don't like the way the filters are presented, you can always trap the filter events to provide a custom-written form that lets the users select criteria, from your check boxes for example. Doing this will retain some of the versatility, and the convenience of toolbar/menu access to the criteria form. For more information, look in the Help file for the Filter and ApplyFilter events. Rick Sprague
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top