I have a question about adding a combo box in a form. I would like to know in a search form linked to a query, if you can add a combo box (linked to another table for the records) and if you don't select anything in the combo box, the query will treat the combo box as a wildcard?
I have watched a few of your videos but haven't found anything that can help me with this issue.
Adam Schwanz
@Reply 4 years ago
Query Criteria
Like IIf([Forms]![FormName]![ComboName] LIKE "*",[Forms]![FormName]![ComboName],"*")
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Visitor Forum.
