direct a text box to a parameter?

[ericschramm2000]

I want to put two text boxes at the footer of a report that display beginning and ending dates that were entered as parameters (like To: and From: ). But, the report contains a couple charts from completely different queries and the beginning and ending dates apply only to one chart.

What do I have to type in the text box to tell it where to find the parameter values?

Say the name of the query was Query Name...

I tried Query Name.[Beginning Date] but had no luck.

Thank you!
Eric

 

[llkhoutx]

On method is to save those dates in textboxes (visible or not) on a form and then reference those textbox fields in your report.

 

[ericschramm2000]

On method is to save those dates in textboxes (visible or not) on a form and then reference those textbox fields in your report.

That's part of the problem, how do I reference them? -- What's the style for referencing something like that?
I tried the period thing (Query Name.[Beginning Date]) like I said, but I'm not really sure how to reference a field of a particular query.

Thanks for replying!

 

[llkhoutx]

The report footer textboxes "ControlSource" should be

=forms!YourFormName!txtStartDate

and

=forms!YourFormName!txtEndDate

respectively.

 

[ericschramm2000]

The report footer textboxes "ControlSource" should be

=forms!YourFormName!txtStartDate

and

=forms!YourFormName!txtEndDate

respectively.

THANKS! I appreciate the help!