Parameters

  • Thread starter Thread starter Michelle
  • Start date Start date
M

Michelle

How do I remove the pop up window asking to enter a
parameter. I want in the query to find it and remove it
but there is nothing. Is there another way to remove them?

Thank you

Michelle
 
Not sure what you mean.

If you have a parameter request in the query, then it will ask the user when
the query is run. If you want to hard-code the criteria, then do so and
take out the prompt.

If you have a form based on that query, then you should only be prompted
once.

Please better explain what you are trying to accomplish.

Rick B
 
There are generally 2 reasons why a query would ask for a parameter. Firstly
if you have requested one, e.g. Criteria: Like [Enter Date], when the query
is run a box will pop up asking for the date. Secondly if the query or report
is looking for a field that is either spelt incorrectly or does not exist
(field might have deleted after the query was written. Check all the fields
that the query or report is looking for, the pop up box should have the name
of the field at the top, check it's spelling and location.
 
Back
Top