View Single Post
  #1  
Old February 5th, 2010, 12:30 AM posted to microsoft.public.access.forms
Whitney
external usenet poster
 
Posts: 126
Default Multiple filters using combo box

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?