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?
|
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 |