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