Null Value To Show All Records

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

Guest

Hello, I need help. I have a form with a combo box of pre-existing criteria
which is linked to a parameter query. If one of the pre-existing listings is
put into the combo box and then I run the query, it works fine. However, I
am wanting to set it up to where, if the combo box is blank, the query will
return all records. Can someone explain to me how I can do this?
 
Like [your current field data here] & "*"


just change your "=" to a "like" and then add to the end &"*"


Rick B
 
Back
Top