Question for pros - Continues form

[Phalanx]

I Have a continues form designed with a 2 textboxs within it, I've attached a button that suppose to run a query on the record those textboxs are attached to (lets say record ID number is 10, textbox1 contains name: Jorj textbox2 contains last name: Bush) - the query get those fields - 10, jorj and bush and do something with them...

how am I supposed to do this?

 

[Pat Hartman]

Reference the form fields in the query:

Where YourField = Forms!frmName!ctlName AND YourOtherField = Forms!frmName!ctlNameOther;

If the form is a subform then:

Where YourField = Forms!frmName!sfrmName.Form!ctlName AND YourOtherField = Forms!frmName!sfrmName.Form!ctlNameOther;