Glowackattack
01-22-2009, 12:02 PM
I have this afterupdate code built into my form...
Private Sub Owner_and_Beneficiary_Address1_AfterUpdate()
If Me.Billing_Address1 = Null Then
Me.Billing_Address1 = Me.Owner_and_Beneficiary_Address1
End If
End Sub
So, after updating the Owner & Beneficiary address, if the Billing Address is blank, populate billing address with O & B address...
When i step through this code it pulls "Null" For Billing address, and "Test" for O&B address, but it doesnt assign the value to the billing address control like i would think it would.
Am i missing something simple here??
Private Sub Owner_and_Beneficiary_Address1_AfterUpdate()
If Me.Billing_Address1 = Null Then
Me.Billing_Address1 = Me.Owner_and_Beneficiary_Address1
End If
End Sub
So, after updating the Owner & Beneficiary address, if the Billing Address is blank, populate billing address with O & B address...
When i step through this code it pulls "Null" For Billing address, and "Test" for O&B address, but it doesnt assign the value to the billing address control like i would think it would.
Am i missing something simple here??