Combo box

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
 
R

Rick B

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
 
Top