How to have form fields propegated from another table

[blindhawkeye]

I am currently working on a project to make one guys two step job into a single step. Fill out a form it fills out a table for record keeping and then print it out so that it fills out a pre designed government form. There is a list of companies that we use, in the table for record keeping we just need the company name. But for the paper form I need to print the address and employer number in seperate boxes. So I made a table of companies that we use Name, Address, Employer#. So I got it to the point where the form looks up the Companies Name and inputs it into the record keeping table. But I want to have the Address and Employer Number show up in the other fields. (Its the end of the day I may be able to explain it cleaner tomorrow.)

[TheShabz]

look up the DLookup() function and see if that suits your needs.

[pbaldy]

If you mean for data entry:

http://www.baldyweb.com/Autofill.htm

For a report you'd use a query that got fields from both tables.