How do I update a Table from a control (combobox) in a Form?

[Erik Løvaas]

I try again!

I have a Form (frmActivities) that contains a combo-box holding information
on customers. The information
is derived from a Table (tblCustomers). I want the Table to be automatically
updated whenever I enter a new Customer in the Form (frmActivities).

Erik

 

[John Vinson]

I try again!

I have a Form (frmActivities) that contains a combo-box holding information
on customers. The information
is derived from a Table (tblCustomers). I want the Table to be automatically
updated whenever I enter a new Customer in the Form (frmActivities).

Erik

Use the Combo Box's Not In List event. There is sample code at

http://www.mvps.org/access/forms/frm0015.htm