exclusivity on option buttons bound to fields

[accessguy52]

Does anyone know if I can make my option buttons exclusive? - that is, click on only ONE button? Sure, I know you can do this with unbound and option groups, but, it seems that radio buttons that are bound to a field can be ALL be picked, when I only want ONE to be pick from a group. Anyone have any leftover code that does that? Many thanks!!



accessguy52

 

[lupins46]

This is not possible using an option group as it is the group that is bound to a specific single field.

You could program your own using the afterupdate event of each button

opt1_afterupdate()
if me.opt1 = false and me.opt2 = false and me.opt3 = false then ' can't allow no selection
me.opt1 = true
end if

if me.opt1 = true then
me.opt2 = false
me.opt3 = false
else
end if
end sub