Parameter Query Box For Every Field

Asked By 20 points N/A Posted on -

I have created a simple database with 12 fields both text and numeric.

The query I’ve chosen shows the value of each field.

Why can’t the query see the database and gives me a parameter query box for every field when I shut down the database and reopen it?

I should specify that when I save the query, close it and re-open it works just fine.

Answered By 0 points N/A #171227

Parameter Query Box For Every Field



A parameter query is  an advanced query. You can create a query that can be updated easily to refer to a new search term. 

In parameter queries, search terms act as variable criteria and change each time you run the query. 

The solution to your problem requires a very detailed solution, however I was able to find some useful links for you.

Use a parameter to make a query ask for input

Customizing Access Parameter Queries

Hope it helps.


Login/Register to Answer

Related Questions