Option buttons problem

[touchmove]

Good day everyone!


Could you help me with my option buttons problem?


I have an option group on my form with radio buttons in it. When I choose a button, the value is reflected to my table. But when I browse again in every record, option button which I choose before in each and every record doesn't stay the same way. It's now change with the button I recently used.

Some vba code might help the issue but unluckily, I have no idea with it.

Your expertise is appreciated.

 

[ranman256]

If you have the option buttons frame bound to the record, you are changing data. This is what you want correct?

And you do have a frame around the buttons? The FRAME is bound to the data, not the options.
The options change the frame.value. The frame is bound to the table field.

 

[touchmove]

Thanks ranman256 for your reply.

I do have a frame for my option buttons. Using the wizard, I choose save for the latter use. Then, put code to the frame in AfterUpdate event:

Private Sub LeaveTypeFrame_AfterUpdate()
Select Case LeaveTypeFrame.Value
Case 1
Leave.Value = "Annual Leave"
Case 2
Leave.Value = "Leave Without Pay"
Case 3
Leave.Value = "Sick Leave"
Case 4
Leave.Value = "Final Exit"
End Select
End Sub


It works fine. The selected option in the frame reflects on the table. But when I browse again to the form in form view, the selected option for each and every record changes with the option I lastly used.

For example I choose on record 1 - Annual leave; record 2 - Annual leave; record 3 - Sick Leave

It works fine with the table.

But when I browse back to each record. It goes this way: record 1 - Sick Leave; record 2 - Sick Leave; record 3 - Sick Leave


Meaning the lastly selected option doesn't move based on the option you selected for each record.