Help with dynamically setting GROUP properties in REPORT

  • Thread starter Thread starter John Cosmas
  • Start date Start date
J

John Cosmas

I have a report that I've added a GROUP. The group level always stays the
same, but the field by which it is group may change. How would I do that in
code? Is there a GROUP0 property I can set and update the FIELD value like
I would do with CONTROLSOURCE for a TEXTBOX?

TIA
John
 
John,

Check out using VBA code in the "OnOpen" event of your report.

Using code you could check the value of some control on your form, then
using code you can change the contorlsource for the group.

I do not have any code handy that will do this, but check the help file and
then try writing the statement in the VBA window and you should be able to
get enough feedback to make it work.
 
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

Access Create option group without using wizard? 2
Only labels showing up on first page of report 3
Chart in Grouped Report in Access 2007 2
Help with Report Design 1
Pass report's recordsource value to DAvg function call 3
Report Group Count? 2
Open Report with Criteria From Form 6
Dynamic Group Report 2

Back
Top