Search Query

[miss_sunshine]

I have a search form which uses a query to retrieve results. The search criterea is chosen by the user, from 2 combo boxes. A "search" button runs the query.

In the criterea section of the query I have for each field to be searched:

[Forms]![FormName]![ComboName]

(obviously I put the correct form name and combo box name in the criteria)

However, when the search button is clicked, 2 popup boxes appear saying "Enter Parameter Value"

I want the query to run automatically, based on what the user has entered. What am I missing?

 

[shadow9449]

What does the query look like?
What does the table look like?

Etc...

SHADOW

 

[neileg]

Access does that when it does not recognise the reference you put in the query as a criterion. The most obvious cause is mistyping the reference. Make sure that the form you are referencing is open at the time the query runs, too.