Use check box to copy postal address from business address fields in the form.

[WookiesAccess]

Hi guys,



Fairly new to Access 2010 and finding it a little difficult to fix this problem. I have a table which I record business contact details and instead of retyping the postal address I added a check box titled "Postal Address same as Business Address?".
What I was trying to achieve is have the postal fields populate with the current business address data if the check box is ticked.
I know what I want it to do but not sure how to do it.

Any suggestions?

Cheers and thanks!

[RuralGuy]

You would put code in the Click Event of the Checkbox.
Me.Addy2 = Me.Add1
Me.City2 = Me.City1
...etc.

You could also do basically the same thing in the AfterUpdate event of each of the Add1 controls. Then no Checkbox needed. If the mailing addy is different then just overwrite the values. Just a thought.

[WookiesAccess]

Thanks RuralGuy, much appreciated

I thought there would have to be a simple approach to this! I'll give it a try tonight...hopefully I'll be able to that part of it working right!


Cheers