Set criteria in query to not have any criteria so all records show using value in combo box

[achammar]

Hi all,



So I have a very simple query. The criteria of one of the fields is set to be equal to the value of a combo box on a form. It works fine. It only shows the records of whatever is equal to the value in that combo box. My problem is how do I show all the records in case I don't want a criteria. I can't get it to do that. I choose a value in the combo box, then click a button that runs the query. But I haven't figured out how to make the query show all records if I don't want any criteria in that field.

This is the criteria I have in the query in 1 field:
[Forms]![frmSheetPlate]![cboSheetPlate]

Thank you so much for any help!

[CJ_London]

just remove the criteria.

or perhaps

[Forms]![frmSheetPlate]![cboSheetPlate] OR [Forms]![frmSheetPlate]![cboSheetPlate] is null