I have a database of customers and information related to those customers. To add or change information a user selects the customer from a dropdown list (combo box)and then enters/changes the associated information in a subform. The problem is that the customer name the user selects overwrites the first name in the customer table. Any suggestions?