I have a table of people (subscribers table - primary key subscriberID). Each subscriber can have multiple addresses (address table - Primary Key AddID and foriegn key SubID). I want to note which address I should ship a book to in the month of May each year, so in the address table there is a Order check box. Now all of this is on a form with my address information being on a subform. My problem is that I don't want 2 addresses to have the order check box checked. If I have the box checked for address 1 and the user checks the order box on address 3, I want the check on address 1 to be removed. The main form is called: frmSubscriber, the Subform is called Address and the check box is called chkOrder. I assume I am going to put some type of code on the chkOrder_AfterUpdate event but I am not sure what the code should be.:banghead: