Make a field on a report equal an input field on a form

[Eddy Sincere]

I have a form into which I enter a specific number of days, let's say 90. I dropped a button which runs a report that pulls from a query to pull all records with dates which fall between today's date plus the 90 days. That's all working fine.

I want the "# of Days" text field on the report to display the number that determines the date range (90).

Input form



Report

[pbaldy]

=Forms!FormName.TextboxName

Hope you're missing the smoke.

[Eddy Sincere]

Got it! Thanks for the quick reply. I was thinking that I had to do some VBA but it turns out it was much more simple than that.

HA! The smoke is actually not bad today but the last week has been pretty miserable. Everyone has sore throats and watery eyes.

[pbaldy]

Happy to help! The form does have to remain open by the way.

Same here; the vagaries of the wind. Crystal clear one day, can't see across town the next. I played golf near the Mt Rose Highway last week and it was beautiful but we could see the smoke blowing over the mountains. I drove back into town and it was like fog.

[ssanfu]

@ Paul
I'll trade you the smoke for the earthquakes..... 6.1 today.

[pbaldy]

No thanks Steve. Been there, done that.

i have a cousin in Anchorage though; I better see how he's doing.