Passing form value to a report header

[Johnny Drama]

I've got a form that requests a start and end date to be inputted by the user. Once the user click the okay button the form passes the values to the report which queries the data and generates the report just fine. What I can figure out how to do is take those same start/end date values and have them show up in the report header so I can dynamically change the report title when it's run. I tried using the same thing I have for the query =[forms]![date selected]![fromdate] but then the report presents a criteria box when it's run. Any ideas?

 

[pbaldy]

That should work. Double check the spelling of the form and control names, and make sure the form is open when the report runs.

 

[Johnny Drama]

Grrrrrrr.....Since you said that should work I tried it again...this time I used the expression builder and it worked just fine. I must have fat fingers. Guess I'll use the expression builder to be safe from now on. Thanks once again, Paul.

 

[pbaldy]

Happy to help. At least you have an excuse. I have skinny fingers and I still manage to garble half of what I type.

 

[vbaInet]

I have skinny fingers and I still manage to garble half of what I type.

No way Paul. You've spoilt my image of you. I've always imagined you to be of a much bigger build.

 

[pbaldy]

I'm built like that tall, lanky Leigh Purvis up in northern England. Surely you know him; since England is so small I assume everybody knows everybody!

 

[vbaInet]

it's so tiny it's unbelievable. I've even met your daughter and her family up in West Sussex (I believe).

 

[pbaldy]

She has a family now?!? That brat didn't even tell me she finally made me a grandpa.

 

[vbaInet]

Oops... I wasn't supposed to tell you.