Dynamic Grouping in VBA 1

[NSNewey]

Hi

Is it possible to set which field a report is grouped on in the report module code?

I have a report generator form which the user selects various filters to view a report of Customers. I want to be able to set the grouping of the report based on the users filter selection. In other words, if the user has filtered by County, I want to group on town. If the user has filtered on Country, I want to group on County etc.

I have opened the reports module and in the Report_Open event cannot see in the intellisence options anything other than Me.GroupHeader(0) which I cannot assign the control source to.

If this is possible, I would also like a text box in the group header to display the appropriate value (ie the town name or county name etc)

Any help will be much appreciated.

Neil

 

[dhookom]

Check out Allen Browne's page Sorting report records at runtime.

Duane
Hook'D on Access
MS Access MVP

 

[NSNewey]

Works a treat thanks