Query Question

[whodeycp]

Is it possible to have an expression in a query be equal to the current value from a textbox on an open form?

 

[Axworthy]

Yes, in the Field: row, put in Forms!frmFormName!txtFieldName and it will add an Expr1: name to it.

 

[kjv1611]

You can do this from the Query Design view:
Under the field you want to compare/filter:
[OL][LI]Click in the Criteria box, and then click on the build button, or else, right-click in the box, and select build.[/LI]
[LI]In next screen, click the "=" option[/LI]
[LI]Next, click the plus sign next to "Forms" in the left box, choose your form (double-click)..[/LI]
[LI]In the middle box, find your control, and double-click it - it should show up now correctly in your top text box (the build window)...[/LI][/OL]

--

"If to err is human, then I must be some kind of human!" -Me