Getting a Value from an Option Group

[Bhujanga]

I created a group of option buttons using the wizard. Now I want to decide which action to take based on which option was selected, I can't seem to find the syntax testing which button is selected. I thought maybe something like:
"IF [Forms]![Form Name]![Option Button Name]=1 THEN..."
would work, but it says I entered an expression that has no value.

[ADezii]

I created a group of option buttons using the wizard. Now I want to decide which action to take based on which option was selected, I can't seem to find the syntax testing which button is selected. I thought maybe something like:
"IF [Forms]![Form Name]![Option Button Name]=1 THEN..."
would work, but it says I entered an expression that has no value.

Assuming your Option Group Name is optTest, and you went with the Default Values (1 to 6) for each Option:

Select Case Me![optTest]
  Case 1
    MsgBox "You chose Option 1"
  Case 2
    MsgBox "You chose Option 2"
  Case 3
    MsgBox "You chose Option 3"
  Case 4
    MsgBox "You chose Option 4"
  Case 5
    MsgBox "You chose Option 5"
  Case 6
    MsgBox "You chose Option 6"
End Select

[Bhujanga]

Assuming your Option Group Name is optTest, and you went with the Default Values (1 to 6) for each Option:

Select Case Me![optTest]
  Case 1
    MsgBox "You chose Option 1"
  Case 2
    MsgBox "You chose Option 2"
  Case 3
    MsgBox "You chose Option 3"
  Case 4
    MsgBox "You chose Option 4"
  Case 5
    MsgBox "You chose Option 5"
  Case 6
    MsgBox "You chose Option 6"
End Select

Yep, that does the trick. Thanks.

[ADezii]

Yep, that does the trick. Thanks.

You are quite welcome.