I have two fields in Access form one is [Job Status] and [Term date] I am trying to have a word populate in [job status] based off of what the [term date] field here is my logic is this
If [Term date] is " " or IS NULL I want the word "Active" to populate in the [jobstatus] field
Else if not I want the word "Inactive" in the [jobstatus] field to populate. I tryed the code below but I get nothing. NO error and no words popping up in job status field. I am putting the code in the AFTERUPDATE Property field for Jobstatus
Any help is greatly appreciated.
If [Term date] is " " or IS NULL I want the word "Active" to populate in the [jobstatus] field
Else if not I want the word "Inactive" in the [jobstatus] field to populate. I tryed the code below but I get nothing. NO error and no words popping up in job status field. I am putting the code in the AFTERUPDATE Property field for Jobstatus
Code:
Private Sub Job_Status_AfterUpdate()
If Me.Term_Date = " " Then
Me.Job_Status = "Active"
ElseIf Me.Term_Date Is Null Then
Me.Job_Status = "Active"
Else
Me.Job_Status = "Inactive"
End If
End Sub
Any help is greatly appreciated.