Selecting a single user

[GOU]

Hi,

In a Form showing one user at a time, I'm trying to write
a vba code in the Before Update event of a check box to
popup a message box if there is another user having is
check box checked.

In the best of world this popup would ask if by checking
this user you wish to unchecked the others. I try to do so
using a DoCmd.RunSQL "UPDATE..." but I have an error
message telling me another user has modify the record.

Is it possible to do so differently ?

Thanks.

 

[Scott McDaniel]

Can you use an Option Group to do this? If a record can have only one of
these items checked, then you could put an Option Group control on your
form, add all your checkboxes to the option group, and then Access will take
care of that for you.