Simple Query Not Working (Filter)

[fenhow]

I have a query that filters two tables. 1) Status 2) Name

The status is 1,2,3,4,5 from an option group on my form.

In the query I have <>3 for the status, whereby I only want records that are status 1,2,3,& 5.

When I run the query with all names it works perfectly, however I am trying to run the query for only a select few names versus all of them.

The problem is I do not know how to select only a few names versus all of the names and make it work. When I try to add names i.e "Doe, John" my Status pulls all records including option 3.

Can anyone help? I do not even know where to start seaching.

Thanks.

Fen How

 

[Jon K]

You can place the names in a multi-select list box on the form for the user to make selections and dynamically build the query using VBA code from the On Click event of a command button on the form based on the selections in the option group and list box.
.