Pull info from field to place in report header

[Autoeng]

I run a report that is based on queries. The queries have Between dates parameters. I set up a form for the queries to get the dates from. I would like to pass this date information into the header of the report.

Engineering Monthly Report 10/01/02 - 10/31/02

I placed a text box on my report and set the Control Source to

Forms![frmDates][Start Date]"-"[Stop Date]

When I run the report the text field reports back "#Name?".

What am I doing wrong?

Autoeng

 

[RichMorrison]

Just like you would do it on a form:

=Forms![frmDates]![Start Date] & "-" & Forms![frmDates]![Stop Date]

RichM

 

[Autoeng]

Thanks Rich. Exactly what I was looking for.

Autoeng