filtering data in MS Access

[chippyles]

I have two combo list fields (unbound) on the top of the page. I have a query that in the fields to look up they say [forms].[fQA_Raw_Materials].[Vendor] and .[Heat]

The problem I have is how do I deal with the combo lists when one is null and the other is selected?

Also, when both of the selections are null (when the form just opens) I return no data. Makes sense because the combo fields are null.

I need somthing to say iif null then ignore [forms].[fQA_Raw_Materials].[Vendor] and .[Heat]

Any thoughts??

 

[DoubleD]

Are they Combo Boxes or List Boxes as this makes a big difference.

If they are combo boxes, use this:

Like Nz([Forms].[fQA_Raw_Materials].[Vendor],"*")
Like Nz([Forms].[fQA_Raw_Materials].[Heat],"*")


I am what I am based on the decisions I have made.

DoubleD