Easiest is to bind the option group (frame) to a table or updateable query field, assuming you correctly created the association between the frame and the buttons. You should know that by seeing "Option Value" property on the Data tab for the button property sheet. If you can't bind the frame, you can use an update query or vba that gets the frame value.