So i have an Address dynamic combo box that is based off of my ClientName field. The ClientName field on the form hides the ClientNameID (primary key), displays the ClientName on the Form and stores the primary key in the associated table. That works great. However my dynamic combo [Address] that is based off of the ClientName field does not work. It too is suppose to be a two column combo box displaying Address, hiding AddressID and storing Address ID. But it seems broken. It DOES store the AddressID in the table. It DOES display only the Address and hide the primary key on the form. However, when you go back through the form to previous entries the Address field is blank. Displays neither the Address or hidden key. Even though it still displays the correct ClientName and the AddressID field is filled in properly on the associated table. Here's the funny thing, if the ClientName is the same as the most recent one I entered in new form then the Address will display correctly in previous records. What is going on?