Passing Variables from form To report

[mrweatherbee]

Hi,

This problem seems as though it should be simple to solve, but I just can't get it. Basically, I have a form, with two text boxes where users can enter in a date range (one date in each box...a from and to box). Then when a button is clicked, a report is called up that queries the records within the specified date range. That works fine, but I want to have the date range that the user entered into the text box printed on the report as well, but just can't seem to get it to work? Any help or advice would be greatly appreciated...thanks...

 

[JoeMiller]

You can use an unbound textbox to go out and get the dates. I usually put a little narrative in the control source of the unbound textbox like this:

="For dates between " & [Forms]![MyFormName]![MyStartDate] & " and " & [Forms]![MyFormName]![MyEndDate]

obviously you'll need to change the form and control names to match your scenario. Hope that helps!

Joe Miller
joe.miller@flotech.net