Oct 12 2005, 01:50 PM
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.
Oct 12 2005, 01:55 PM
Welcome to Utter Access Forums!
will answer your questions on the Not In List event...
Edited by: Jack Cowley on Wed Oct 12 14:57:12 EDT 2005.
Oct 12 2005, 03:26 PM
thanks so much!! that worked perfectly!!
Oct 12 2005, 03:53 PM
You are welcome and I am glad it solved your problem.