Auto Fill Fields

S

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
 
A

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.
 
Top