i have a form that allows you to create a new record with all the details of a project. there are fields like number, name of project, lead and sublead. all this info is stored on the project table. the lead and sublead names i want to keep track of on a separate table (person). so if the name entered into the lead/sublead combo box is not in the list already, i want it to update the person table with that name, so that it appears on the drop down list in the future. i think that i will use the On NotInList event, but i do not know what sql/vb code i use to update this new value into the person table. thanks.

Welcome to Utter Access Forums!

This article will answer your questions on the Not In List event...

hth,
Jack

Edited by: Jack Cowley on Wed Oct 12 14:57:12 EDT 2005.

thanks so much!! that worked perfectly!!

You are welcome and I am glad it solved your problem.

Jack