How to Restrict User To Select One Field in a continuous form

The below screenshot will tell what I want to do and attaching a sample db for testing.

Any suggestion will be helpful to me

Hi Sixth,

Try using OptionButtons instead of CheckBoxes. Please note that each set of OptionButtons must be in a Group.

You may either want to add a 3rd OptionButton on each line for 'Not Accepted or Rejected Yet', or if Access allows it, double click somewhere to clear both OptionButtons on the line if neither Accepted nor Rejected is ready to be selected.

Lewis

Untested possible solution:
How about some VBA that states if

Please Login or Register  to view this content.

and then conversely for the other alternative.

Originally Posted by LJMetzger

Try using OptionButtons instead of CheckBoxes. Please note that each set of OptionButtons must be in a Group.

Thanks for the suggestions

I changed the checkboxes to option button and made a Option Group for that but it is not working as intended and allowing to select both

Originally Posted by alansidman

How about some VBA that states if

Please Login or Register  to view this content.

In fact VBA will be more handy for this simple task and in the same way I tried the above code before posting this question. But unfortunately it is not working with continuous form and simply locking all the records instead of locking the actual record

Hi Lewis,

Thanks for the links, as per your advice I am using the Option Group in my continuous form and assigned the result to my table field