Address field question

[Miller84]

If I have a set of address fields looked up by a customer ID number, how can I get acess to copy them into a shipping address field, which can allow the address to be altered if delivery is needed to an address which differs from the billing address?

The example I have seen is in the Northwind sample database on access but I cannot see how to replciate this in my database. I have the shipaddress shipcity etc in the orders relation and the customer as usual in the customer relation.

Any help would be appreciated. Thanks

 

[Pat Hartman]

Take a look at my Sample. It shows two ways to do this. One by referencing columns from the combo (preferred) and the other by using DLookup()'s (not recommended).