in access 2007, In my form i place option group in that i place two buttons i.e.., yes,no. for option group frame i set control source property field. i want to store this sold field. when i open a form i.e., form view option buttons highlighted are not showing when i select the option buttons.
when i deselect the control source property. the selected option buttons are shown but not saved in to table field(Sold).
and also already saved records option button value is changed button its not changing all the other fields are changing. when i check to go to next records option button values are not changing depending on tables value.