I have a form that controls which data is selected in a query. This works fine, as long as the user enters data in all fields. What I want to do is allow the user to enter data in some, not all of the combo boxes, and get data out. Is there a way using wildcards? What happens is that the query runs using a blank field as a search option, and as such does not return any data! Can I use a default setting to set it to wildcard and select all data?<br>
<br>
Pointers, suggestions, comments. I may be being very stupid, but I cannot find any details on this anywhere!<br>
<br>
Thanks.
<br>
Pointers, suggestions, comments. I may be being very stupid, but I cannot find any details on this anywhere!<br>
<br>
Thanks.