Pop-up Box to change report titles

[CB100]

I am building a database for returned product and the product name changes
with each report. I want to build a dialog box to ask for the Title of the
Report and have it automatically change the name.
Would someone help me with this?

Thank you

 

[Tom van Stiphout]

On Fri, 22 Aug 2008 06:17:00 -0700, CB100

(I'm assuming the report title could not be calculated from data in
the database)
Build a form (frmReportLauncher) with a Report Title textbox
(txtReportTitle). Probably also a button to launch your report
Then in the Report_Open event write:
Me.Caption = Forms!frmReportLauncher!txtReportTitle

-Tom.
Microsoft Access MVP

 

[Klatuu]

If you don't have any way of determining what the title should be without
having to have the user type it in. There are a couple of ways you could do
it.

Put a text box on your form for the user to enter the title. Then in the
Open event of the report, put the value of the text box in a label on the
report:

Me.lblTitle = Forms!FormThatOpenedMe!txtTitle

Or, you could use an Input Box in the Open event of the report:

Me.lblTitle = InputBox("Enter Report Title")