Need code to create a single title for multiple reports

[PamelaD]

I have created a database of which I must make two dozen copies; this app will be used to house details of a legal cases.The application has several reports, each of which requires an identical text/title label, to identify the title of the case e.g. "US EPA v Toxic Chemical Co." or "US EPA v Hazardous Waste Dumper"

How do I write a line of code that I only have to enter once (in a module), such that it will put the appropriate label/title at the top of each of the reports?

Thanking you in advance!

 

[cghoga]

within the form whre you kickoff the report generation process create a text field called i.e. Report Name.

on each of your reports, create and place within the header or wherever you want the title to go, a text field.

in the control source of the text field, call the location of where you entered the report name in step1 above

for example in the control source enter...

=forms!yourformnameinstep1!fieldnameofreportvalue.value

be sure to leave the form you are referencing open as you are referencing a value on that form and it will error if not left open.

hope this helps.

 

[PamelaD]

cghoga: Thanks very much for the help! Best regards,Pamela