Removing parameters from a query

  • Thread starter Thread starter Todd
  • Start date Start date
T

Todd

I have a query that prompts the user for starting and
ending dates for the query as parameters.

Now I'm building a new query that uses the original query
as its basis, but I don't want the user to be prompted for
the parameters this time.

Do I need to duplicate the original query without the
parameter criteria, or is there a way in the new query
to "turn-off" the parameter prompt?

Thanks for any help
 
You should remove the prompts. There are many better methods of filtering a
recordset/query.
 
So what are the better methods?
I have bracketed parameters in a lot of my queries so that
when reports run, the users are prompted for various
things. What is the better way to do this?
 
I display the results of queries in either forms or reports. In most cases,
I use the WHERE clause of DoCmd.OpenForm and DoCmd.OpenReport to send
criteria to the query. In a few rare cases, I might use criteria in a query
that references a control on a form.
 
Back
Top