option buttons

[tiguy]

Hi All

Does anyone know how to have an 2 option button on a form and if you click on one have that saved to an access data base so the next time the form is loaded it shows that button clicked?

Thanks reston

[dee-u]

AddNew
If Option(0)=True then
Field1=True
Field2=False
elseIf Option(1)=True then
Field1=False
Field2=True
end if
update

Private Sub Form_Load()
rsrecordset.open ......
if rsrecordset!Field1=True then
Option(0)=true
else
Option(1)=true
end if
End Sub