Solved Query criteria. When no match, return all records (1 Viewer)

[mafhobb]

Hi. I have a simple query with the criteria based on a value in a field:

=[Forms]![frmDocumentParameters]![cmbCleanerSelected]

This works fine when I have data in the combobox. However, what I need is for the query to return all records if the combobox is empty.
How do I do this?
mafhobb

 

[mafhobb]

I figured it out!

=[Forms]![frmDocumentParameters]![cmbCleanerSelected] Or [Forms]![frmDocumentParameters]![cmbCleanerSelected] Is Null