I am new to Microsoft Access 2000, and am having a little trouble figuring
out how to do somthing I am sure is very simple.  If you have the answer
maybe you could attach a sample and mail to [log in to unmask]

If I have two tables, customer and order header, (as follows)...

    CUSTOMER          ORDER HEADER

    custid                       orderid
    cust                          custid
    shiptoaddr               shiptoaddr
    shipttocity                shiptocity
    shiptostate              shiptostate
    shiptozip                  shiptozip

In a form I want to enter the customer id, (orderid autonumber), then have
Access fill in the "default" shiptoaddr/city/state/zip into the order header
fields of the same name.  If necessary the user can either accept these
values, (by enter/tab through), or change them, and they will be recorded
with the header.  I cant seem to figger out how to "auto-fill" these fields.

Any help appreciated.

             PCSOFT maintains many useful files for download
                     visit our download web page at:
                     http://nospin.com/pc/files.html