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.

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
--
Don''t forget to rate the post if it was helpful!

Email address is not valid.
Please reply to newsgroup only.


"Asnell" wrote:

> 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.