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

E

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
 
J

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
Click to expand...

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

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