Save Record Message on a Form

D

DV

I entered the folloing in the BeforeUpdate of a form:
Private Sub Form_BeforeUpdate(Cancel As Integer)
Dim iAns As Integer
iAns = MsgBox("Are you sure you want to change this record? Hit ESC to undo
changes", vbYesNo)
If iAns = vbNo Then
Cancel = True
End If
End Sub

When I'm prompted (YES/NO) to change the record, if I select "NO" I get a
second message - This Recordset is not updateable - with an OK button. How
can I either elimnated this, or change the message to read "Record Not
Updated".
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top