VBA is causing my imported data to change when I open it in form view

[thoughtgrenade]

I appended imported data from Excel to my main table, and all appended values are there. However, when I open my form to view a data row in FormView, certain fields are erased without my doing anything except open, view, and close the form. I suspect it's because of the way I have my VBA set up.

Private Sub SUSPEND_AfterUpdate()


HandleSuspension
End Sub

Private Sub HandleSuspension()
If Nz(Me.SUSPEND, 0) Then
Me.DATE_EFFECTIVE.Enabled = True
Else
Me.DATE_EFFECTIVE = Null
Me.DATE_EFFECTIVE.Enabled = False

End If
End Sub

Both SUSPEND and DATE_EFFECTIVE are the fields getting erased. And upon form open, the DATE_EFFECTIVE field is still grayed out because the SUSPEND isn't checked even though both previously existed in TableView. Is it because of the AfterUpdate event? How can I solve for this problem?

[RuralGuy]

You do not get an AfterUpdate event unless you change the value in the control through the user interface (UI). Open, View and Close will not cause this to happen.

[orange]

In addition to Allan's comment, what exactly is the purpose of this line

If Nz(Me.SUSPEND, 0) Then

? What data type is SUSPEND?