Access perameter Query

  • Thread starter Thread starter ITperson
  • Start date Start date
I

ITperson

I have a query I need to create that is based on 1 query and 2 tables.
What is need is for the perameter to only prompt for another criterion if
the person selects yes on the prompt for criteria.

Ex:
When the user runs the query (via report), they could need to enter as many
as 50 or so criteria. In the query, presently, I have 49 prompts for
criteria ([Enter Code Number 1] to [Enter Code Number 49]. I cannot enter
any more than that because the string is too long for Access.

A user could Enter 10 Codes to look up in the tables/query, or it could be
75, it will vary each time.

Is there a way to have Access prompt for criteria as normal, but have
another button on the prompt that asks if they would like to enter more
criteria? Have Access pop up with another prompt for criteria only if the
person wants it to, otherwise stop prompting and retrieve the results?

Thank you
Terry
 
Here is a method that might work for you. However you start the report use
it to delete all records from a table that you enter criteria. Then open the
table in a form for data entry. Have a button on the form to run the report
when all criteria entries are made. Have report source from a query that has
the criteria table not joined. Use criteria field from criteria table as
criteria in the query.
 
Back
Top