Don't Understand "Public" Variables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am confused about the meaning of "Public" variable. My main report
declares "Public strStaffGrp As String" at the top of the module. My
subreport needs to compare strStaffGrp to a Detail field during formatting,
but I can't see strStaffGrp at that point. But the footer of the same
subreport, during printing, is able to change the content of an unbound field
according to the content of strStaffGrp -- i.e., the footer can see
strStaffGrp during printing.

What am I missing and how do I use strStaffGrp during Detail formatting?

Thanks.
 
Show the code for both cases. Also, which event of the Report embedded in
the Subreport Control are you using in the case where it isn't working?

Larry Linson
Microsoft Access MVP
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Subreport page break in label controls or textbox controls 6
Report Footer, multi-column rpt 4
Access How to prevent subReport from breaking across pages? 1
mutiple reports 2
Hide Main Report Page Footer on Subreport pages 10
SynNeed to account for null values in subreports 2
Calculate Subreport totals in a main report Group footer 3
print Report Footer on 2nd to last page and a chart on last page 1

Back
Top