-
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!!!
-
Trap for the specific error and, when you encounter it, add it the new record in via DAO. Then refresh your data control.
-
I Hope Your Using A DBCombo.. For The Clients Names..After You Have Entered The Data In All Your Text Boxes and Combo.You Will Have To Have An UpDate Button To Click..
Private Sub UpDateCommand_Click()
Data1.UpdateRecord
Data1.Recordset.Bookmark = Data1.Recordset.LastModified
End If
After that the data base will be updated with all the information and ready for your next input..
good luck Johnzea
