Automating field population on a form

G

Guest

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

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top