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

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Query Parameter using multiple options 0
Combo Box Question 4
Parameter Query With Null Values 3
Mult-Value Select returning ID# not text. 4
combo box filter 1
Query with parameter from form control returns no records - HELPPLEASE! 2
Result on Combo box return prior record data 4
Combo Box and First Record 5

Back
Top