[RESOLVED] Creating Option buttons based off Table Values

Hey everyone,

I was wondering if it's possible to write VBA code to create option buttons based off of table values. For example.

My table contains 1 column and it is a parent table.

Activity
--------
Run
Walk
Jog
Sprint

Would it be possible to create option buttons automatically when I open a form based off of the values under Activity???

Thank you!

Quote:

---

Would it be possible to create option buttons automatically when I open a form based off of the values under Activity???

---

yes quite possible, but you would need to give thought as to how you will position them

Westconn,

Sorry for the late reply.
I guess positioning them in the correct location would be the second issues I'd come across. But how would I create an option button with code? I am familiar with looping through a table to name my option button just not creating one.

Thank you.

vb Code:

shtobject.Shapes.AddOLEObject ' requred parameters for type and position

Perfect, thank you.