Option Button & Update Command Button

[Ash]

Hi

I am very new to Access 2003, In form, I am creating 4 option button in option group and Command button (update) in the form, Once I select any option and click Update Button it has to be updated in my table, I don't know how to link that option group into my table. Could anyone enlighten me... it would be very helpful to me..

Thanx in advance..
Ash

 

[wiremonkey22]

How are you telling it what to update are you using a parameter update query

 

[missinglinq]

You're not really giving us much to work with, but generally speaking, you refer to the frame that Access places around the Option Group. Access will name it something like Frame0, so if you don't rename it you'd refer to its value, which would be an Integer of 1 to the number of option buttons. Here's a very basic example using the option button selected to popup a messagebox with the appropriate color listed:

Private Sub Frame0_AfterUpdate()
 
 Select Case Frame0.Value
   Case 1
    NuColor = "Red"
   Case 2
    NuColor = "White"
   Case 3
    NuColor = "Blue"
 End Select

 MsgBox NuColor

End Sub