Changing Report Control Values with Code

[freewilly]

Hi team

I want to change the title of my report based on filtering the user chose.

I can change the value of the control with:

[Reports]![ReportName].lblTitle.Caption = "New Value"

When I put:

?[Reports]![ReportName].lblTitle.Caption

into the immediates window I get the new value, but the actual Report still shows the value it had in design view.

How can I get the report to reflect the changes I have made?

Thanks

FW

 

[LonnieJohnson]

In the report's On Open event, you can check the form that the user used to set the criteria and set the caption at that point.

ProDev, MS Access Applications
Visit me at ==>

http://www.prodev.us

Contact me at ==>lonniejohnson@prodev.us

May God bless you beyond your imagination!!!