Option Group set up...Now what?

[mpmoore]

I have several Option Groups set up in my form. The only problem is that I don't know how or where to define the values for the options. I have scoured several books to no avail. I realize this is a very basic question, but assistance would be greatly appreciated.
Michael

 

[PaulF]

if you have an option group (Frame0) with 3 toggle buttons Toggle1, Toggle2, Toggle3 each toggle button is assigned a value (i.e. Toggle1 = 1, Toggle2 = 2, Toggle3 = 3, the value is shown on the Data Property Tab for the toggle button as Option Value. In the AfterUpdate for the Option Group, use a Select Case Statement to define the code you want to run based on the selection.

Private Sub Frame0_AfterUpdate()
Select Case Frame0
Case 1
' Toggle1 Seledcted Do this Code
Case 2
'Toggle2 Selected Do This
Case 3
'Toggle3 Selected Do this
End Select
End Sub


PaulF