I thought this would be very quick, but I can't get it right....I have a report "Forecast Accuracy Report Main" with a subreport "Forecast accuracy" (that's the name of the subreport control, the subreport itself if "Forecast Accuracy Subreport"). The subreport has a control called txtCount. I have labels on the main report and I want to set the visibility of these labels depending on the value in txtCount.
I was trying to put code in the OnOpen event of the main form:
If Me![Forecast accuracy].report.txtCount>3 then
if me![Forecast accuracy].report.txCount>6 then
If me![Forecast accuracy].report.txtCount>9 then
However, I can't get VBA to come up with lblBias2.visible, visible is not in the list of options that VBA gives me.
Also, am I correctly referencing txtCount?
Let me know if you need clarification.