changing report titles

[Ray]

Hi

I have a report opened buy 18 different buttons, each
filtering a different value using VB.

Is there a way to get access to automatically display the
filter on a cover page as a title to the report. (instead
of having 18 reports with predefined titles).

I currently have to manually input a title which is time
consuming and a possible cause for errors.

Thanks in advance
Ray

 

[John Nurick]

Hi Ray,

You'd have more chance of a good answer if you posted in the appropriate
forum, viz. microsoft.public.access.reports.

I'd try putting a textbox (hidden if you want) on the same form as the
buttons, and writing code so that when the user clicks one of the
buttons the appopriate title is placed in the textbox before the report
opens. Then put a textbox on the report to display the title, with a
ControlSource like
=Forms![NameOfForm]![NameOfTextBox]

I think you can get a cover page by using a Report Header with a page
break at the end of it.