One criteria form for many reports

[rdw456]

Hi all

I have been trying to use one form for many different reports. The basic form "year selection criteria" is used on all of them. I want to change the caption and some labels for each different report. I have opened the form on the open event of the report changed the caption and some labels through code. This works ok but the code just continues and does not stop at the form to allow you to enter the criteria. The report then opens on top of the form. So I am looking for some creative solution.

Thanks in advance

Bob

 

[Ranman256]

You don't need code. The query used In the report will reference a caption text box on the form. The report uses the query field:RptCaption.
The date range is also on the form, which The query also uses.