Auto Fill Fields

[Sam A]

Hi
I would like on a form, to complete some fields.
EG am detailing an order placed by a customer. The
customer details are stored in a seperate table. I have a
look up to find the customer, but then I need to have
fields with address phone etc filled with the data from
that table, and be able to add data to the fields relating
to the order.
I am sure I have done this before but am drawing a blank
today for some reason.
Please help
Sam

 

[Allen Browne]

The Northwind sample database has an example of how to do this.

Open the Orders form in design view, and look at the AfterUpdate event
procedure of the CustomerID combo.