query criteria based on the value of a text box

[prmitchell]

I wish to run a query where the criteria for the query is the value of the text box where the cursor is
I know how to get the value in the text box
Me.[textboxname].Text

but I don't know then how to correctly use this as the criteria in the query

NB: the value is in a text box not a combo box.

The process is
the user types in a value and optionally clicks a button to run the query where the criteria is the value in the text box

thank you in anticipation

Peter

 

[John Big Booty]

Use;

Forms!YourFormName.YourFieldName

as the criteria

 

[prmitchell]

Thank you for your reply John, but
I want to use value in a field on one record within the subform
so trying
Forms!SubformName.FieldName
gives me the Enter Parameter Value dialog box

unfortunatelt

 

[John Big Booty]

Book mark this link for future reference, it show the syntax for referring to subforms their controls and properties from various relative locations. you will be looking at;

Forms!MainformName!SubformName.Form!ControlName