change label on report

[ppoindexter]

i have a report that is based on a parameter qry..how do i set up the report so that it asks for a title (label) that will print on the report.....

(the title will depend on the specific data i enter in the para qry) i do not want to have to create a different report for each of the various titles that i will need.

thanks
pat

 

[Rob.Mills]

If you've setup the title as a textbox; in the control source put 'Title' (assuming you have no field in the recordsource that is named that).

So when you go to open or print the report it will prompt you for this field.

 

[ppoindexter]

many thanks!!