Query with selection criteria

[John liem]

I have a query with a "vendor" field which I can select using the combobox (contains 5 vendors) in a form (Fm_Main).
I use this criteria in the "vendor" field to run my query:
[Forms]![Fm_Main]![Cbo_Vend].
It works as long as I choose a vendor from the combobox on the Fm_Main, but how can I get the query of all vendors at once?. I have tried to fill in blank in the combobox, but it doesn't output a result.
John.

 

[John liem]

Hi Lushman,
Thanks for your reply, but I don't know what is variance matrix, I am just a beginner ....

 

[Jon K]

Add this in the Or: cell below the Criteria for the Vendor field:-

[Forms]![Fm_Main]![Cbo_Vend] is null



When nothing in the combobox is selected, every record will be returned.

 

[Mile-O]

just adjust the variance matrix.

Ignore that - it's just a spam message!

 

[John liem]

Jon,

Thanks a lot ... it works as I want!