View Full Version : Should be easy....


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??

Glowackattack
01-22-2009, 12:08 PM
Figured it out...this code works just fine.

Private Sub Owner_and_Beneficiary_Address1_AfterUpdate()
If IsNull(Me.Billing_Address1) Then
Me.Billing_Address1.Value = Me.Owner_and_Beneficiary_Address1
End If
End Sub