Equivilant of [FORMS]! command in a report 1

[Stevehewitt]

Hi Guys,

I have a unbound form with two unbound text boxes. These are for entering in the criteria of a query which is used as the control source of the report in question.

I would like to display the content of these two text boxes onto the report / page header in the report. I have tried the same expression as I have used in the queries:

[Forms]![frmReportDateSpecific]![txtStartDate]

But I'm getting the very helpfull error of "#NAME?#!

Any help appreciated.

Thanks in advance,


Steve.

 

[earthandfire]

When you refer to a form control, the form must be open.

 

[Stevehewitt]

The form is open. The user open up frmReportDateSpecific and enter in the two date ranges. When they click on "Run" it opens the report which is based on the query. The query uses the above FORMS string to get the data.

Should the above string work?

Thanks,


Steve.

 

[earthandfire]

In which case, yes it should work. Double check that the control that you are referencing is actually called txtStartDate. I've lost count of the number of times I've forgotton to change Text25 to the name I wanted to use and then spent ages looking elsewhere for a solution to the problem!

 

[Stevehewitt]

Hey,

Not too sure what I'm doing wrong, but it seems to be working fine in the report header - just doesn't like it when it's place in the page header. No idea why, but seems to be fine now!

Cheers,


Steve.

 

[ZmrAbdulla]

[COLOR=red]=[/color][Forms]![frmReportDateSpecific]![txtStartDate]

This may work in the page header/footer too. But not sure about the pages except the page 1

________________________________________
Zameer Abdulla
Visit Me
Hold your child's hand every chance you get.
A time will come when he or she won't let you.

 

[Stevehewitt]

Doh!

That's why it wasn't working!

Enjoy the star and thanks again Zameer!


Steve.