Return all records in query-based combo box if query returns no re

[Guest]

I have a combo box based on a parameter query for which the user inputs the
infomation needed in a text box. How would I have the combo box show all
records if the result of the parameter query returned no records?

 

[strive4peace]

instead of imbedding the criteria IN the query ... construct the SQL for
the combobox when the requirements change (like the AfterUpdate event of
whatever is the criteria)

for better understanding of constructing SQL, download and read this:

Access Basics
http://allenbrowne.com/tips.html
Tips for Casual Users
Access Basics: free tutorial - Word document by Crystal (Access MVP)

30-page Word document on Access Basics (for Programming) -- it doesn't
cover VBA, but prepares you for it because it covers essentials in Access.