I have a combo box within a form in Microsoft Access that shows a persons last name and first name. By picking a name I can see all the information on my form based on that persons name. However, I am unable to type a new persons name into the combo box and have it automatically update the actual First and Last name fields on the form if a record for them does not already exist. I keep getting a not in list error and what not.Is there a special way to allow a combo box to accept data entry? I have tried most of the ways in the property box with no success.
Thanks a lot for your help!!!