Help with Auto Fill

  • Thread starter Thread starter Marco
  • Start date Start date
M

Marco

Hi Everyone
I have a data base with a Client tab with billing address and a Policy
Tab with physical address. I would like to set up a checkbox on the
policy tab that will auto fill the Physical address if it is the same
as billing. What would be the best way to make this happen? VBA with a
on click event on the checkbox or just a macro? The simpler the better.
If you can outline the steps I would greatly appreciate it.

Best Regards
Marco
www.classactinsurance.com
 
Private Check1_Click()
If Check1 Then 'match only if checkbox is checked, not if unchecked
PhysicalAddress = BillingAddress
PhysicalCity= BillingCity
'etc.
End if
End Sub
 
Back
Top