I have a form that was designed by a person previously employed at my work. I need to add a combo box on a form with a couple of doctors name. I created a combo box and linked it to the table i created with the doctors names. Problem is that when i set the box to Dr. Smith, it puts dr smith on every single record in the database. If i create a new record and put it to Dr. Jones, every single record including the new record i just created says Dr. Jones. How do i make the box Save for every new record? And only apply to records in the future?