Automating field population on a form

[Asnell]

I have a form with a subform inserted, and would like to add a button that
the user would push, and it would automatically fill in some of the fields in
the subform from the main form.

Main form has company name, address, city, state, zip. The subform has
people associated with that company, and I want the user to be able to click
on a button if the person's direct mailing address is the same as the main
company address, city, state, etc. I am pretty sure that I need to create a
macro, but I haven't been able to find a good step by step guide on how to do
it.

 

[Dale Fye]

I wouldn't create fields for the company address fields in the Employees
table. I would probably just add a yes/no field (UseCompanyAddress) and a
checkbox (chk_UseCompanyAddress). Then, if the company address changes, you
don't have to update all of the individual records.

HTH
Dale