I have a form based on a query, it is a basic Support Call logging form. I have a combo box on the form and I can select Engineers names within that combo box and change the data shown on the form. I have done this with a criteria in the select query ([Forms]![Call Log Listing]![engineer]).
I would like to be able to enter "ALL" in the combo box so as to show all records on the form regardless of Engineer.
Any ideas gratefully rcvd