I have a date in my form that folks fill in when they have completed that record. The date will be blank if they have started the record or have not started at all. If they have started completing the form by selecting pass or fail from the dropdown for each of the 9 questions in the form and need to do some research in order to finish, the form should show 'pending' since it was started and not complete. I created a box in the form header and put the following code in the on open, on click, after update and before update and non seem to work unless they actually make a change to the form.
If IsNull(Me.DateReviewCompleted) = True Or Me.DateReviewCompleted = "" Then
Me.Pending_lbl.Visible = True
End If
If IsNull(Me.DateReviewCompleted) = False Then
Me.Pending_lbl.Visible = False
End If
My question is: "Where do I put the code so that it shows the word 'pending' in the form header if the record was started but not completed.
Thanks for any help.
If IsNull(Me.DateReviewCompleted) = True Or Me.DateReviewCompleted = "" Then
Me.Pending_lbl.Visible = True
End If
If IsNull(Me.DateReviewCompleted) = False Then
Me.Pending_lbl.Visible = False
End If
My question is: "Where do I put the code so that it shows the word 'pending' in the form header if the record was started but not completed.
Thanks for any help.