Here is a code i've just created and it works well, but i was wondering if it is possible for this message to show up only once? this is just a reminder message and i wish for this message to appear only once. I want the message "How many corrective actions have you created?" to appear only once but message "Record has been saved!" to appear always based on if statement. check my code out.
Private Sub save_record_GotFocus()
If Me![TOTAL CORRECTIVE ACTIONS] >= 1 And Me![NUMBER OF CORRECTIVE ACTIONS] = 0 Then
MsgBox "How many corrective actions have you completed?", vbOKOnly
Me![NUMBER OF CORRECTIVE ACTIONS].SetFocus
Else
If Me![DATE].Value Then MsgBox "Record has been saved!"
End If
End Sub
Thanks to everyone in advance!
Private Sub save_record_GotFocus()
If Me![TOTAL CORRECTIVE ACTIONS] >= 1 And Me![NUMBER OF CORRECTIVE ACTIONS] = 0 Then
MsgBox "How many corrective actions have you completed?", vbOKOnly
Me![NUMBER OF CORRECTIVE ACTIONS].SetFocus
Else
If Me![DATE].Value Then MsgBox "Record has been saved!"
End If
End Sub
Thanks to everyone in advance!