Linking a query field to a text box in a form

[Moxioron]

Hello all.

I knew how to do this at one time, but for the life of me....I can't remember.

I want to launch a query using a form with a Beginning Date and an End Date. Here is the criteria field I have in the query:

Between [Forms]![frm_Transaction Detail Inquiry]![Beginning Date] And [Forms]![frm_Transaction Detail Inquiry]![End Date]

The text box control source I have in the form:

=[qry_Detail]![Trans Date]![Beginning Date]

And

=[qry_Detail]![Trans Date]![End Date]

Where am I going astray? Thank you.

 

[Norie]

Are the textboxes on the form named in the criteria and do they have the names [Beginning Date] and [End Date]?

Also, how are things not working?

No values returned?

Incorrect values returned?

Errors?

 

[Moxioron]

Sorry. I get a #Name? in the text box in Form View mode.

The name I have is Beginning Date for one and End Date for the other text box.

Thanks for your help.

 

[Moxioron]

I figured it out....I was looking incorrectly using the query as the control source for the text box form.