Which form event do I use (1 Viewer)

Angel69

Registered User.
Local time
Today, 08:18
Joined
Jun 11, 2013
Messages
86
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.
 

Users who are viewing this thread

Top Bottom