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
 
Back
Top