run time error 2487

prabhus

Registered User.
Local time
Yesterday, 22:06
Joined
Mar 14, 2012
Messages
67
i used the below code in my subform and working fine. but when i link this subform to my navigation form, i am getting runtime error 2487 while closing the navigation form.

how to fix this?

Private Sub Form_Close()
'Provide the user with the option to save/undo
'changes made to the record in the form

If MsgBox("Changes have been made to this record." _
& vbCrLf & vbCrLf & "Do you want to save these changes?" _
, vbYesNo, "Changes Made...") = vbYes Then
DoCmd.Save
Else
DoCmd.RunCommand acCmdUndo
End If
End Sub
 
what is runtime error 2487? a description would help

Also, on what line of the vba code does the error occur?
 

Users who are viewing this thread

Back
Top Bottom