"Ron" <ronSPAMBLOCKERwest777@earthlink.comwrote in
news:eMvug.714$157.159@newsread3.news.pas.earthlin k.net:
Quote:
Hi,
>
I've got a report that has a subreport on it. On the
subreport I've got a label and control printing.
>
I'd like to have both the label and the control print only if
it's not the default for the control. The label/control is a
lblDrLicNo/DrLicNo. Default for control is "1111" (string).
>
I put the routine to make both label and control invisible if
DrLicNo = "1111" into the OnActivate in the subform and just
running the subform, it works fine. But as soon as I run the
main form with the subform within it, it prints the label and
control regardless of what the control has in it.
>
How can I get done what I want?
>
TIA
ron
>
First, read
http://www.mvps.org/access/forms/frm0031.htm
Second, I think you might be better to use the OnFormat Event of
the subreport as the location for your code.
--
Bob Quintal
PA is y I've altered my email address.
--
Posted via a free Usenet account from
http://www.teranews.com 
