groupon from a form

  • Thread starter Thread starter billybanter67
  • Start date Start date
B

billybanter67

Hi all,

I was wanting to change how a report opens based on a drop down box
called "groupcriteria" in a form.

Eg, I will have monthly, 1/4 and year as options.

The report is called "MonthlyDataALL"


I have this code which works in the on open for a report but I would
prefer for the code to be based in the form instead if it is possible.

Me.GroupLevel(0).GroupOn = 4

Any ideas?

Thanks
 
I tried this and it works in the onopen in the report so why reinvent
the wheel I guess.

Me.GroupLevel(0).GroupOn = Forms!DataDrill!Grouping.Column(1)

The dropdown box has "Monthly";4;"Yearly";2 as the row source.
 
Back
Top