Group By In VBA

[FontanaS]

I Want To Use The Group By Feature In VBA For A Report, Based On A Combo Box Where The User Decides What Field To Group By.

Is There A Proprty That Will Do This? I Know There Is One For Sorting And Filtering, But Have Not Found One For Grouping.

Me.cmbxApprop.Value = stores the value i want to group by

 

[nagornyi]

Wouldn't Sort do the job?

 

[dhookom]

Check Allen Browne's web page

http://members.iinet.net.au/~allenbrowne/ser-33.html.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.