Multi-Select Form

[ckeezer]

I would like to create a form that my users can select multiple check boxes from and have only those records that meet the criteria come up in a search.

See attachment for a look at the form.

I need to be able to let the user have the ability to put in a name and then select any of the check boxes and then click on a search button that will execute a query that will bring up the results.

Any help with code or at least a point in the right direction would be nice.

Thanks,
Chuck

 

[gromit]

Hi -

What you describe is certainly doable - with a little VBA and patience.

The approach that I am most familiar with is to use the boxes to build a SQL statement. If you only search when you hit the search button, then the code for the OnClick event will examine the status of each of the buttons, built the correct WHERE statement for the SQL and then go out and query the database with it.

If you still have questions, I can try to help.

- g