You can't save this record at this time

[a]

access 2007

How can I cancel this message ? and display custom message

You can't save this record at this time

May have encountered an error while trying to save a record if you close
this object now, the data change you made will be lost.

Do you want to close the database object now

 

[Minton M]

access 2007

How can I cancel this message ? and display custom message

You can't save this record at this time

May have encountered an error while trying to save a record if you close
this object now, the data change you made will be lost.

Do you want to close the database object now

You need to use the Form Error event and handle it from there.

In the handler....

Private Sub Form_Error(DataErr As Integer, Response As Integer)
End Sub

.... DataErr gives you an error codde and Response let's you suppress
the Access message. There are some good examples in help on how to do
this.

Hope this helps,
James