leafsrock100
Registered User.
- Local time
- Today, 05:12
- Joined
- Jul 29, 2010
- Messages
- 17
I have a checkbox on my form that determines whether the shipping address is the same as the billing address.
My VBA code looks like the following:
Private Sub Check_Same_As_Billing_Box_AfterUpdate()
If Check_Same_As_Billing_Box = True Then
ShippingAddress = BillingAddress
ShippingCity = BillingCity
ShippingProvince = BillingProvince
ShippingPostalCode = BillingPostalCode
Else
ShippingAddress = ""
ShippingCity = ""
ShippingProvince = ""
ShippingPostalCode = ""
End If
End Sub
However, when I click the check box on the form, only the shipping address populates with the billing address data but nothing else
What am I doing incorrectly?
Any help would be greatly appreciated,
leafsrock100
My VBA code looks like the following:
Private Sub Check_Same_As_Billing_Box_AfterUpdate()
If Check_Same_As_Billing_Box = True Then
ShippingAddress = BillingAddress
ShippingCity = BillingCity
ShippingProvince = BillingProvince
ShippingPostalCode = BillingPostalCode
Else
ShippingAddress = ""
ShippingCity = ""
ShippingProvince = ""
ShippingPostalCode = ""
End If
End Sub
However, when I click the check box on the form, only the shipping address populates with the billing address data but nothing else
What am I doing incorrectly?
Any help would be greatly appreciated,
leafsrock100