07 Help! Generating a report based on dropdowns

[JBurlison]

created a form with several Drop downs, S/N, Location, Manufacturer, Model, Model Number, and Owner.

All the drop downs are based off of forms, i queried the main inventory to have this info and a couple peaces of information. applied the relationships.

If i try to make a macro filtering the conditions, if i leave any of the fields blank nothing comes up in the search.

is there a VB code that i can use that wont include "null" fields or will this not work with 6 different filters applied all in one macro.

furthermore after the search i want the ability to print the search results using a report design.

is this possible?

 

[Dennisk]

in the query criteria enter something like


=Forms!YourForm!YourControl or Forms!YourForm!YourControl is null

when you close the query Access will automatically create another criteria column for the null .

 

[JBurlison]

I tried creating a form from the query to see multiple items but 07 is not apply the filters at all. it just comes up blank, even when i enter valid criteria.