Is it possible to choose no criteria on a user-defined criteria form?

  • Thread starter Thread starter HeatherMichelle
  • Start date Start date
H

HeatherMichelle

Guest
I created a form that allows the user to choose the criteria that they want to see on a report using =Forms!formname!controlname in my query. It works great but I want to also allow the user to choose nothing and return all records instead of limiting them to choose just one type of record. Is this possible? Before I created the form my query had the [Enter parameter] on one criteria line and [Enter parameter] Is Null on the next criteria line and that was working great for my use but I need to create a simple form for other users.
 
A simple way may be to enter a "*" in the control that you use as a param. There are other ways...
 

Users who are viewing this thread

Back
Top Bottom