criteria on a query 1

[jay2502]

I am creating a database that needs to look professinal and I am struggling with my parameter querys because the msgbox that opens, when =[...] is typed into the criteria on a query, is not what I want. Can i not do it in a form?

 

[PHV]

A common is to use a parameters form with a button to launch the query.
In the query the criteria is: =[FORMS]![name of form]![name of textbox]

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886