Conditionally Suppress a Subreport in Main Report

[JoeyB_99]

I am using Access 2007.

I have a simple subreport that appears - as intended - beside a subtotal amount in a main report.

I want to suppress/hide this subreport when the subtotal amount is greater than $1,000. How can I do this?

I'm fairly new to VBA code and event procedures.

Any help would be greatly appreciated.

 

[llkhoutx]

Hide the subreport based upon the value on the subreport's OnFormat event.

 

[JoeyB_99]

Thanks, but can you please elaborate? What exactly should I enter into this property?