Hi I have a query where I pass it a value from a form. If the value on the form combo box is "All" then I don't want to restrict the query otherwise I want to restrict it to just the value selected in the form.
Below is the "Criteria" field that contains the code.
In your table you don't have a "*" stored as a value in the field your are searching. The "*" means nothing special to your database, it is just a character like any other. What is the syntax of your query? One solution might be to compose a different query, with a different WHERE clause, when the user chooses the "All" option. A good place to do it is the Click event of the combo box.