Uncheck check box

[iridium]

I have a form for all the companies that I work with. I also have a
sub form with the contacts form those companies. In a company I can
have multiple contacts but only one of those is the one for the sales.
I have check boxes to determine if a contact is for accounting,
shipping or sales. I would like to make it so if I check the box for
sales in one contact and if there were another contact with the sales
box check it would uncheck that and check the other one. What is the
easiest way of doing this.

Thanks

 

[Guest]

Create an Update query that will set the field for the checkbox to False.
Filter it to exclude the contact in the current record. Execute the query in
the After Update event of the checkbox.