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

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

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.
 
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.
Click to expand...

Um?

Just base the form on your Query. You're doing it right; what's the
problem?

John W. Vinson[MVP]
 
With the [Enter Paramater] in the query, the user would have to know how I
referenced things so I have the form set up with a combo box that the user
can select which criteria they want but I cannot figure out what to put in
the control field so that all records are returned. I need this form to be
simple-stupid for the users. Instead of them entering in the criteria they
want I am forcing them to pick the criteria from the list. I was told
something about entering "*" but I cannot get it to work.

John Vinson said:
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.
Click to expand...

Um?

Just base the form on your Query. You're doing it right; what's the
problem?

John W. Vinson[MVP]
Click to expand...
 
Back
Top