Need to update information in table from form

[Credendo]

I've been working on an access database at work to store caller information. The form has the following fields

Callers name
ID
Phone number
Plant Code
Store Code
Dept #

Now I've got the form to lookup the persons information after putting their name in the combo box so that it fills in the correct information in the other fields, but if any Name isn't in the list, or if someone changes the information in the fields after the name has been chosen, I want to update that information in the table that the combo box queries, so that any new customer that calls in will be added. Does anyone know the VBA code I would need to do this?

Thanks in advance
Ryan

 

[PHV]

Have a look at the NotInList event of the Combobox object.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Credendo]

I figured it would be that event, but I'm not sure how to code it in that event. How do I write the data to a table that's outside of the forms scope