report controller

[bobby213]

Hi Im trying to make a form be a report controller. How do I reference the values of the headers and footers on a report from a form. I tried
Reports![associate report]![groupheader0].visible

but it didnt work can anybody point me in the right direction or know of a sample databse that has this feature I can take a look at ?

thanks,
bobby

 

[Pat Hartman]

Rather than referring to the report (before it opens) from the form, you will need to refer to the form from the report in the report's Open or Load event.

If Form!yourformname!yourfieldname = something Then
Reports![associate report]![groupheader0].visible = True
Else
Reports![associate report]![groupheader0].visible = False
End If