Option Group selection

[mahmud1180]

I want to use option boxes in the from using a if function like

If (Me!CustomizedDates = True) Then


D(i) = CD(i)

ENd if

Its actually not working. How can I use conditional functions if one option is selected.



Thanks in advance

[ranman256]

If your option group has only 1 option , then use a checkbox.
if it has > 1 option , the VALUE of the item you picked is contained in the FRAME. (the box)

You place a frame on the form, in the frame you put all your options, each w a different value
The VALUE of the option picked is assigned to the FRAME.VALUE

so the frame has
yes = 1
no = 0
maybe = 2

if user picked MAYBE then
the frame ,fraPicks.value = 2

be sure to NAME the objects so they are more understandable, in properties, other tab, NAME.

[mahmud1180]

I have two options so I am using option group. I actually have no idea where the frame is. I have put the option group in the form. The options have distinct option value such as 1 and 2. Is it the frame value? or is it in the property of the options?

[mahmud1180]

Ah got it ! The whole box is called the frame.... Thanks

[Missinglinq]

...The whole box is called the frame...

Now you've got it! In an Option Group you always refer to the Frame, itself, not to the individual Controls, whether Checkboxes, Radio Buttons or whatever. Example code would be something like this:

Private Sub ActualFrameName_AfterUpdate()
 
 Select Case Me.ActualFrameName
  
  Case 1  'First Button
     'Code for First Button goes here
  
  Case 2  'Second Button
     'Code for Second Button goes here
  
  Case 3  'Third Button
     'Code for Third Button goes here
 
 End Select

End Sub