Run Report - Hide/Show Subforms and Subform Fields

B

Bryan

Greetings,

I need to write an on click event procedure that runs an access report.

The event needs to check the value of a check box form field. If the value
is checked I need to hide or display particular subreports and/or specific
fields on a subreport.

For example, if form field is checked and report is executed:

if form field checked
Run main report.;
Show contacts subreport;
Hide rate field on services subreport;
else
Just run default main report (i.e., show contacts and show rates);

I am an experienced coder I just have no experience coding in an MS
environment. Time is limited. I appreciate any help I can get.

Thanks!
 
Top