Getting Dates in Report

I am trying to get the header of my report to tell the user the Beginning and
End Dates of the data (which they imput into a form to get the proper time
period for the report).

I put this into the header:

=Forms!Reason_Code_Report_Form![Beginning Date]

and a like line in for [Ending Date]

Even though the report returns the right data, the date never come across -
always returns #Name?

What am I missing here that will make it work???

Thanks!

It should be in the Control Source property of a Text Box on your report.
Is sounds like you have it somewhere else.

"GoBrowns!" wrote in message
...
I am trying to get the header of my report to tell the user the Beginning
and
End Dates of the data (which they imput into a form to get the proper time
period for the report).

I put this into the header:

=Forms!Reason_Code_Report_Form![Beginning Date]

and a like line in for [Ending Date]

Even though the report returns the right data, the date never come
across -
always returns #Name?

What am I missing here that will make it work???

Thanks!

I do have it in the Control Source property of my text Boxes. It just does
not return the dates.

Thanks for the suggestion - what else should I look for?!?



"Klatuu" wrote:

It should be in the Control Source property of a Text Box on your report.
Is sounds like you have it somewhere else.

"GoBrowns!" wrote in message
...
I am trying to get the header of my report to tell the user the Beginning
and
End Dates of the data (which they imput into a form to get the proper time
period for the report).

I put this into the header:

=Forms!Reason_Code_Report_Form![Beginning Date]

and a like line in for [Ending Date]

Even though the report returns the right data, the date never come
across -
always returns #Name?

What am I missing here that will make it work???

Thanks!

GoBrowns! wrote:

I am trying to get the header of my report to tell the user the Beginning and
End Dates of the data (which they imput into a form to get the proper time
period for the report).

I put this into the header:

=Forms!Reason_Code_Report_Form![Beginning Date]

and a like line in for [Ending Date]

Even though the report returns the right data, the date never come across -
always returns #Name?

What am I missing here that will make it work???


The obvious reason for #Name is because [Beginning Date] is
not the name of the text box on the form. Carefully check
the name of the text box to make sure it is ***exactly***
the same as the name used in the report.

If it really is the same, make sure the form is open the
entire time the report is open.

If you're sure those conditions have been met, then check
the name of the form and try enclosing the form name in [ ]

--
Marsh
MVP [MS Access]