Hi.
I have a stock file with say 50 groups(can be variable) and say 20-25 stock codes in each group.

I want to create one commandbutton on a form for each group (so I end up with say 50 buttons)
(This bit I think I can do )

In the click event of each button I want to run code like:
Select * from MyStockFile where Stock_group = MYGROUP
... but the MYGROUP is variable (Being the Group that related to the commandbutton)

Is there a way of dynamically inserting the code that will run from the click event as it will depend on the Stick Group?

Any suggestions very welcome.

Regards,

Gerard