Using a Union Select All option in an integer based combo box.

[Adam Tippelt]

What I'm trying to do is give users a selection of 'filters' on a form for them to generate a report with. For each of the filters i've also used UNION SELECT to put an (All) option in the drop down lists.

When the report opens it runs a query, so the columns are filtered depending on the value of the combo boxes, or if their value is (All) then it doesn't filter at all.

The query code for each field is like this:

 
WHERE ((Results.BrowserUsed=Forms!ReportFilter!Browser Or Forms!ReportFilter!Browser="(All)")=True) 

(SELECT/FROM code and other fields omitted)


This works fine for all fields, except one. I have one drop down menu that is an integer based field that doesn't accept any code that I put in.

I've tried changing the query to :

 WHERE ((Results.BrowserUsed=Forms!ReportFilter!Browser Or Forms!ReportFilter!Browser Is Null)=True) 

but this also doesn't have any effect.

Has anyone got any idea how the code can be altered to work with integer fields?

Thanks.

[Adam Tippelt]

Nevermind, problem solved. An if statement I'd written for when the integer field was null was changing another variable which was the cause of the problem.