Query with parameter from Form Textbox

[Juan4412]

I can't remember the syntax to use a textbox titled txtName as a parameter for a query?
What's going on is you enter the userName & push a button, and all data relevant to that user is displayed in a query window.

[rpeare]

the paramater name should be [forms]![formname]![fieldname] and you have to enter the data type

if you're talking about a CRITERIA you'd use the same thing ([forms]![formname]![fieldname]) in the CRITERIA line of the query