Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
how to setup event procedure on format?
0 views
Skip to first unread message
Tracey
Nov 9, 2009, 3:07:43 PM11/9/09
to
I have a main report and a subreport. Now it is working very well. But
we don't want everything show up on daily report.
we don't want everything show up on daily report.
On the main report, I put total actual time and target time. If
(totalactualtime-targettime)/targettime<0.1, then I am hoping the
subreport invisible. How can I set this up on the format at event
procedure? Please help.
Thanks,
Tracey
duanehookom
Nov 9, 2009, 5:04:37 PM11/9/09
to
You can set the subreport control to invisible with code in the On
Format event of the main report section that contains the subreport:
Format event of the main report section that contains the subreport:
Me.srptControlName.Visible = Not (totalactualtime-targettime)/
targettime<0.1
This assumes the name of your subreport control is srptControlName and
TotalActualTime and TargetTime are bound to controls in this section
of the main report.
Duane Hookom
MS Access MVP
Tracey
Nov 9, 2009, 6:02:53 PM11/9/09
to
>
> - Show quoted text -
It works. Thank you very much, Duane.
Have a good day,
Tracey
0 new messages