Auto Fill Fields

  • Thread starter Thread starter Sam A
  • Start date Start date
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
 
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.
 
Back
Top