how to call a form value to my query

[NeonSky via AccessMonster.com]

hello, would someone please tell me how to reference a form text box value as
a criteria in my query?

right now my criteria line reads =[Forms]![FormName]![FormTextboxName]![Value]


what am I missing here?

thank you!

 

[John Spencer]

Try

=[Forms]![FormName]![FormTextboxName]



'====================================================
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
'====================================================

 

[NeonSky via AccessMonster.com]

Figured it out....

=Forms![formname]![controlname]

Where formname is the name of your form and controlname is the name of the
object which contains the value you are passing to your query. Thanks.

hello, would someone please tell me how to reference a form text box value as
a criteria in my query?

right now my criteria line reads =[Forms]![FormName]![FormTextboxName]![Value]

what am I missing here?

thank you!

 

[NeonSky via AccessMonster.com]

Thanks John, I think we posted at the same time

Try

=[Forms]![FormName]![FormTextboxName]

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
'====================================================

hello, would someone please tell me how to reference a form text box value as
a criteria in my query?

[quoted text clipped - 4 lines]

thank you!