Group by object

[Maailmapoiss]

Hello!

I have come up for me very intresting problem. How to assign value to subform group by object.
I have main frm and subfrm. when user click a button in mainfrm then it should add value to the subfrm control, but the control is in SQL statement with group by.

If somebody didn't understand I can put up an example.

 

[maxmangion]

but the control is in SQL statement with group by.

why don't you use a query for the subform rather than an SQL statement ?