Check Child Records if check box selected (1 Viewer)

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:

Something like:

CurrentDb.Execute "UPDATE Addresses SET chkOrder = False WHERE SubscriberID=" & Me.SubscriberID & " AND AddressID <> " & Me.AddressID

Hi. I just thought of something as another approach although I haven't really seen it used before, and that is, how about adding an OrderAddressID foreign key field in the Subscriber table to indicate which address is the shipping address? Just a thought...