View Full Version : Option Buttons


md1274
03-26-2001, 08:02 AM
I'm creating a database that prompts the user to select one of the three options. But when the option is selected, the program does not grab the option that was selected. How can I capture the option that was selected?

KevinM
03-26-2001, 08:06 AM
You have to put a routine in the AfterUpdate or OnClick Event of the Option Group like this....

Select Case OptionGrpName
Case Is = 1 ' First Option
[MyField]="Whatever"
Case Is = 2 ' Second Option
[MyField]="Something else"
Case Is = 3 ' Third Option
[MyField]="Something different"
End Select
End Sub

You could also use If Then if you like but I prefer using Select Case as it easier to control.

HTH