Northwind orders form

[Mark Penny]

In the Northwind sample database the Orders form has a drop down CustomerID
box that changes both the "Bill To" address and the "Ship To" address
automatically as the customer ID is changed. In an Access 2003 database I am
trying to make a form that works like this (change the customer ID and the
"Bill To" and "Ship To" address fields update automatically with the
customers (already) stored address, but cannot figure out how this part of
the form works. I would be grateful for any help.

Thanks.

 

[Brian]

In the Northwind sample database the Orders form has a drop down CustomerID
box that changes both the "Bill To" address and the "Ship To" address
automatically as the customer ID is changed. In an Access 2003 database I am
trying to make a form that works like this (change the customer ID and the
"Bill To" and "Ship To" address fields update automatically with the
customers (already) stored address, but cannot figure out how this part of
the form works. I would be grateful for any help.

Thanks.

You need to look at the code in the CustomerID_AfterUpdate event procedure.