Selection to show in Report Page Header

Hi ... I'm stumped again !

What I want to do is to have the dates that have been inputted on a form, appear in the Report page header.

The form is called Select_Inception. This form only has two text boxes called Start Date and End Date, they select on a field called PeriodFrom. There is also an OK button, this is the vba code I have used

Please Login or Register  to view this content.

I've added a text box in the page header of the report and in the control source i've tried this

Please Login or Register  to view this content.

But when I open the report I get #Name?

I'm sure it's something daft I'm doing again.

Cheers
Wrightie

Well there are 2 ways to do it, the one I would use is using TempVars.

On the form you enter the dates on make an ok key or something that when clicked does something like:

Please Login or Register  to view this content.

Then in the 2 text fields you enter the following in the control source: =[TempVars]![MaxBase] etc

These are examples from my database. I use the discounts in the header of a report comparing pricing.

If the form is still open when you open the report you can always use the "me."

Hope this helps,

Dan

P.S. TempVars only works in Access 2007, (I see you have excel 2007 so assumed.)

Np, glad you figured it out.

TempVars are a fantastic addition.