Here's another sample database for this, too:

Using Controls to filter a form's data
http://www.accessmvp.com/KDSnell/Sam...htm#FilterForm

--

Ken Snell
http://www.accessmvp.com/KDSnell/



"Jeanette Cunningham" wrote in message
...
I suggest you download a sample database that uses a form built with combos
and textboxes to do the searching.
This sample shows you how to do all the code to filter the query and get
the records the user wants.

Here's the link
http://www.allenbrowne.com//ser-62.html



Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia



"Whitney" wrote in message
...
Hi,

I'm trying to figure out how to filter a query using the following
criteria:
Start Date and End Date
Plus
Issue or All
Agent or All
Rep or All

In each combo box I have the following:
SELECT [tbl_Issue].[Issue] FROM tbl_Issue union select ' All' FROM
tbl_Issue
ORDER BY [Issue];
etc.

In the query I have the following:
Date: =[Forms]![frmselector]![txtStartDate] And
=[Forms]![frmselector]![txtEndDate]
Issue: Like [Forms]![frmselector]![Issue]
etc.
However, I get a blank query. What am I missing?