MS-Access Report Group by based on Combo box Selection on Form

[Mohsin Malik]

Hello,

I have a question for Microsoft Access report, Is there any way that I would be able to Group the report based on combo box selection by the users.

I have the combo box that has the "Row Source Type='Field List', I would simply want to add an express on the Group by report to group by based on the combo box selected column.

Thanks in Advance

Mohsin

 

[pbaldy]

I use code like this:

http://www.access-programmers.co.uk/forums/showthread.php?t=227908&highlight=Grouplevel

 

[Cronk]

I've never had a situation where I needed to do what you ask.

I don't believe the Group properties for the source data field are exposed to VBA so I doubt if you can achieve want you want, other than to have different reports which are selectable via your combo.

Nevertheless, I'd be glad to be shown I'm wrong and the method to do what you want.

 

[Mohsin Malik]

Thanks guys, I have tried to store the combobox values to TempVar and on report load event assigned the tempvar to Grouplevel control source and it works exactly what I needed.

Cheers
Mohsin