If Is Not Null syntax
Posted on 2008-11-02
Experts, would like to have this afterupdate event work but have a syntax. I have looked around on EE and did not find a solution so I decided to ask a question. It is my code so there might be a better way to code it. Basically, on AfterUpdate and if the field txtDateApprovedOrDeclined is not null (meaning that adate was entered) I would like the other two fields to say Inactive and 100. thank you
Private Sub txtDateApprovedOrDeclined_AfterUpdate()
If (IsNotNull(Me.ApprovedorDeclinedcbo)) Then
Me.Status = "Inactive"
Me.PrcntComplete = "100"