Query with a combo box

[cooldisk2005]

All,
I want to do a query on a field that is a combo box. The field name is: status, and the values in that field are: working, submitted, & approved. I have created a search form that I want to use with this query.

This is the syntax I have:

If Not IsNull(Me.status) And Me.Status <> "" Then
strWhere = strWhere & " (tbl_PAF.status) Like '*" & Me.status & "*' AND"
End If

With the above it is only allowing to search for one value in the combo box.

With the code above I want to be able to get results for 2 values from the combo box.

How would I change the code above to pull everything that is working and submitted?

Please help if anyone can.

Thanks so much in advance.

 

[dhookom]

Search the FAQs for several solutions that use a multi-select list box.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[lars7]

You could look here too.

http://www.fontstuff.com/access/acctut17.htm