Query problem

P

Patrick

I'm trying to query a table, in which the criteria comes from a form. Why
does Access keep throwing parameter boxes at me that don't tell me what
parameter to input, and how do I get rid of it?!

Thanks!
 
G

Guest

because you have confused access and it's wants
clairification.
in the query's criteria pane put this
[forms]![yourform]![yourtextbox]
this way access will know where to get the parameter.
 
J

John Vinson

I'm trying to query a table, in which the criteria comes from a form. Why
does Access keep throwing parameter boxes at me that don't tell me what
parameter to input, and how do I get rid of it?!

Thanks!
Click to expand...

It's bringing up the message either because the form is not open at
the time you run the query (open the Form first, enter the criteria,
and *then* open a Form or Report based on the query, perhaps from a
command button on the form itself); or because you have the criteria
syntax incorrect. The proper syntax is

=[Forms]![NameOfTheForm]![NameOfTheControl]


John W. Vinson[MVP]
 
Top