Passing value from Form to Report

[mithani]

Hello,

I have made one form for report purpose. When I enter Start date and End date, I get report of the date range. What I am looking that I want to print the start date and end date in my report. How can I reference date text box in my report?

thanks

mithani

 

[boblarson]

Put a textbox on your report and set the controlsource to

="From " & [Forms]![YourFormName]![YourFromDate] & " to " [Forms]![YourFormName]![YourToDate]

 

[mithani]

Thanks Bob,

I entered this code:

="From " & [Forms]![PO-REPORTS]![OstartDate] & " to " [Forms]![PO-REPORTS]![OendDate]

But showing this error "The expression you entered contains invalid syntax"

Thanks

mithani

 

[boblarson]

Where did you put the code? Can you upload a screenshot?

 

[mithani]

thanks bob

 

[boblarson]

Got it - thanks that helped me see it

="From " & [Forms]![PO-REPORTS]![OstartDate] & " to " & [Forms]![PO-REPORTS]![OendDate]

 

[mithani]

Bob you are Great!

 

[boblarson]

The part that helped me see what I should have seen to begin with was the other part of the error message about a missing operand.