Combo box

  • Thread starter Thread starter Matthew
  • Start date Start date
M

Matthew

I have a query that looks to a combo box on a form for a
parameter. Is there a way to set it up so that if the
combo box is left blank, all records are returned. (no
parameter) and help is much appreciated. thanks,

matthew
 
in your query put...

Like [forms...] & "*"



The &"*" will add onto the end and make it a broader search. adding it to a
blank will pull all.


Rick B
 
You must log in or register to reply here.

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

How to use txtboxes and Combo boxes in a form 3
Query error, too few parameters 0
Combo Box executing query, issues 4
Combo Box Value question 4
Combo Box in a Query 3
Access Control on subform / combo box requesting parameter 0
query relelated to 2 combo boxes 2
Basing a query on the selection in a Combo box parameter 2

Back
Top