I have a form that I'm using to track dates of when I am processing some documents. I have a checkbox on this form that I use when I receive a revised version of the document. I have a 2nd form to track the revision information. I would like to automate the first form to give a user message telling that I have received a revision to the document when that box is checked. I was told to use the on Current event. I have tried to enter the code in, but it will only give me the message when I open the form initially, not when a separate record is opened. I am using a combobox within the same form to search for the records. Is there something with my code that I need to change to get the message to pop when I access the record? Or do I need to create a macro to do this, and if so how would I go about doing that? Here is the copy of my code.
Private Sub Form_Current()
If Forms![Groups on Payhold].[Revised Packet Received] = True Then
MsgBox ("GID has received a Revised Packet for this group. Please use the Revised New/Renwal Form."), vbInformation, "Revised Packet Received"
End If
End Sub
My first form is called Groups on Payhold, and the checkbox is named Revised Packet Received.