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.
Re: Is this a Sound Database Design? -- code: SwitchTabs ... The "command buttons" (put in quotes because I actually used label... Dummy is an unbound control -- really tiny because I use labels instead ... Sometimes, the subforms do not have linking fields, like a lookup subform ...Dim mCurrentTab As Integer, i As Integer, mBoo As Boolean ... (microsoft.public.access.tablesdbdesign)
Re: Is this a Sound Database Design? -- code: SwitchTabs ... The "command buttons" (put in quotes because I actually used label controls) to switch subforms are colored so that you can see which one is active ... TabID is an unbound control -- it is set when the form loads ... Sometimes, the subforms do not have linking fields, like a lookup subform ...Dim mCurrentTab As Integer, i As Integer, mBoo As Boolean ... (microsoft.public.access.tablesdbdesign)
Re: IIf or Nz function ... If it is a report with a subreport, ... If it is a form with a subform,... referring to the non-existent control in the subform ... If it is in fact a report with a subreport,... (microsoft.public.access.forms)
Re: Subreport name appears behind data ... when you create a subreport within a main report, ...*control* which has a label attached to it (same as a subform control ... main report, and dragged it, the attached label would move along with it. ... The subreport name is "quote subform".... (microsoft.public.access.reports)
Re: subreport and null value problem ... >about the label control.... >events or control source.... Format event of the **section** containing the subreport.... When the report is viewed stand- ... (microsoft.public.access.reports)
