Query: getting criteria from a textbox in a form

lguzman · October 29th, 2004, 04:10 PM

I have created an action query (Update query), which I want to launch from a form. I have created two textboxes in that form, "Start" and "End". I would like the update query to use the information entered in these textboxes by the user, as its criteria. How do I do this? >="!FORMS!FORMNAME!TEXTBOXNAMESTART" and <="!FORMS!FORMNAME!TEXTBOXNAMEEND" ???????

HELP!!!

[LGuzman]

JLovell · October 29th, 2004, 07:30 PM

Close, but no cigar.

>=[Forms]![Formname]![TextBoxNameStart]

You should also choose Parameters from the Query menu and explicitly define the parameter and its data type.

John Viescas, author
"Microsoft Office Access 2003 Inside Out"
"Running Microsoft Access 2000"
"SQL Queries for Mere Mortals"

lguzman · November 1st, 2004, 10:16 AM

Thank you!

[LGuzman]