Calendar dates in report

[Minkey]

I'm sure one of you guys or gals can help.
I'm trying to display the selected dates from a calendar form in a report (text box) using the following control source:

From date : [Forms]![frmCalendar]![txtClick1]
To date: [Forms]![frmCalendar]![txtClick2]

The report seems to work fine except the text box which displays #Name?
Im sure Im missing something obvious any ideas.

 

[KenHigg]

Is frmCalendar open when the report prints?

 

[Minkey]

Yep the form stays open until the user closes it

 

[KenHigg]

And txtClick1 is the name of one of the date fields?

 

[Minkey]

Yep - txtClick1 is the from date which is populated from the date select from the calender.
It works fine when used in a query i.e. Between [Forms]![frmCalendar]![txtClick1] And [Forms]![frmCalendar]![txtClick2]
Could the fact that the report is being generated from this query be an issue ??

 

[KenHigg]

Hum... No, I use this on my reports on a regular basis with no problems. I would do a plain generic text box with some test text in it and see if the report will display it...

 

[AN60]

Try this, it is what I use on reports when I use a form + calendar to select dates;

="Dates From" & " " & [Forms]![Name of your Form]![txtFrom] & " " & "To" & " " & [Forms]![Name Of your Form]![txtTo]

You will have to edit "name of your form" and "txtFrom" and "txtTo" to reflect your particular field or form names.

 

[Minkey]

I'll try that out - though I don't have access to the db moment - thanks