How to use option button to store value into table

[dododo]

Hi,



I want to make option button in access to allow user choose status like: Single, Married and Widower

Single
Married
Widower

When user choose the value must save into table. How to do this? Pls help

Thanks

[June7]

Why do you need code for this? Why not use a form bound to table and a combobox bound to field? This is basic Access functionality. Data entry on form.

[dododo]

I don't want to use combobox. I want to use option box. pls help

[June7]

By option box do you mean an option group with 3 radio buttons?

An option group control can be bound to field. The option group values must be numeric. This means number 1, 2, 3 (representing Single, Married, Widower) can be saved directly to record. If you want to save text descriptor that will require macro or VBA.

So combobox is the easier method for saving text value.

[dododo]

That's fine. Thanks. I will use combo box instead.