Re-Create them as an option group, then it will automatically behave as you want.
It is the Frame with XYZ at the top in the form design toolbar.
DLookup Syntax and others http://access.mvps.org/access/general/gen0018.htm
Please use the star below the post to say thanks if we have helped !
↓↓ It's down here ↓↓