Help with Auto Fill

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
 
G

Guest

Private Check1_Click()
If Check1 Then 'match only if checkbox is checked, not if unchecked
PhysicalAddress = BillingAddress
PhysicalCity= BillingCity
'etc.
End if
End Sub
 

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

Similar Threads

Auto Fill Field 1
Prevent a new record when inputting a form 2
abcdef filter question 2
Access to Word Documents 2
Clear entries in a tab on a form 2
How to add additional info without losing info 4
Auto fill in same record 4
Help with Update Query and Filter by Form 1

Top