Frame Option Group, select a value by VBA (1 Viewer)

dungstar

Registered User.
Local time
Today, 16:54
Joined
Mar 13, 2002
Messages
72
What is the way to select a check box in an option group by VBA? I'm not sure what property to use.

I have a form with a combo box of 100 items on it, and an option group with 100 checkboxes. I am trying to synchronize the two, i.e., when an item in the combo box is selected, the appropriate check box should be checked.

Thanks
 

Elana

Registered User.
Local time
Today, 09:54
Joined
Apr 19, 2000
Messages
232
Yikes! 100 Check boxes? I am curious why you have chosen an option group to capture the information. I would think instead you would have a table containing those 100 options and allow the user to choose the appropriate option with a listbox or combobox (or synchronize the listbox or combobox through code to match your first combobox).

Maybe you could post your database so I could take a look?
 

Users who are viewing this thread

Top Bottom