changing heading of reports

[cihow81]

Hi,

I am doing a group option with 3 options in it. When an user ticks one of the option and click print buttons, a report will be displayed. When the user ticks option A, and click print button, I want the report heading to change to heading A. When the user ticks the second option, and click the print button, i want report heading to display heading B. Can someone guide me on how to do this?
Currently i have three reports linking to the three options, and i find it very ineffective. As the only variable thing within the 3 reports is the heading only...

 

[KenHigg]

What about this; On the reports on open event, check the frame that contains the option buttons.

select case forms!myForm!myFrame.value
case 1
   me!myReportheader = "Some Text"
case 2
   me!myReportheader = "Some Text 2"
case 3
   me!myReportheader = "Some Text 3"
end select

Would this work?
Ken

 

[cihow81]

Hi,
Is this a form of marco command??? Where do i insert the code into???

Select Case [FType]
Case 1 'Ftype = 1
stDocName = "rpt_1"
strFilter = "Name = Forms!frm_europe_1!Name"
DoCmd.OpenReport stDocName, acPreview, , strFilter
Case 2 'Ftype = 2
stDocName = "rpt_2"
strFilter = "Name = Forms!frm_1!Name"
Filmtype1 = " Cast Film"
DoCmd.OpenReport stDocName, acPreview, , strFilter
Case 3 'Ftype = 3
stDocName = "rpt_3"
strFilter = "Name = Forms!frm_1!Name"
DoCmd.OpenReport stDocName, acPreview, , strFilter
End Select