RuralGuy and Orange,
Thanks so much for your help! I just used the BeforeUpdate to validate some date fields and it works perfectly. I had the code in another Event Proc and it wasn't running but as soon as I put in the Before Update it worked.
Now I'm ready to tackle the partial records. Here is my question.... The user selects an Analyst from the drop down menu. The control is holding the value until I initiate my save sequence which validates that certain fields contain a value before I write the record. How can I use the Before Update to clear the field. It will clear it before I initiate the record validation which is multiple fields.
I apologize if I am not understanding this for the partial records. In my mind the logic works greats for something like a date validation where you don't want the value in the field unless it is a valid date.
UPDATE SOLVED: I found this code and it does what I need it to do.
Code:
Private Sub close_Click()
Dim Answer As Integer
If Me.Dirty = True Then
Dim Response As Integer
' Displays a message box with the yes and no options. Response = MsgBox(Prompt:="Do you wish to discard data?", Buttons:=vbYesNo) '
If statement to check if the yes button was selected. If Response = vbYes Then
DoCmd.RunCommand acCmdUndo
DoCmd.Close
Else
Me.Clear.SetFocus
End If
Else
' The no button was selected.
DoCmd.Close
End If
End Sub
Thanks again for all your help!!!!! Very much appreciated! Project is done! Moving on to the next one!