I have a form with a command button to add a person if the person is not listed in my combo box on the form. I can add the person, but when I go back to the form, the name is not in the combo box? What do I need to do?

Get Litwin's Access 97 Developer's Hanbook, it go the code for NotInList.

Don't set combo box to "Limit to List"
Then you can either choose one from the list or type in a new one. The trick is that the combo box should pull a distinct listing of all the names in the name column only. Then every time the combo box is populated it picks up the new names.

"Solutions" database not in list shows how to add to list and combo.