Using Radio Buttons Instead of Combo Boxes

[ProAdjuster]

In my 'Contacts' table, I have a lookup field (named Status) to my 'status' table. I would like to have that field referenced in my form by radio Buttons instead of a combo box. I have 3 options.

Is there a way to link 3 radio buttons?

Also, can I link the group to the lookup field?

 

[genomon]

The radio buttons can created as a control array which makes referencing the values easy. Don't know how you would link them to the table though....

Silence is golden.
Duct tape is silver.

 

[JerryKlmns]

Maybe the option group could do it

Me.OptionGroupFrame.Value=rst.Fields("Status")

 

[ProAdjuster]

The option Group worked.

Thanks!