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
|