Error 2501

[Abacus1234]

I am using the following:

Private Sub PurchasePrice_LostFocus()
DoCmd.RunCommand acCmdSaveRecord
End Sub

In the case where a record is not yet created, I get

Runtime error 2501
The Runcommand action was cancelled.

I'm thinking that the least change I can make to this code, is to put

On Error Resume Next before the DoCmd line

Will this work?

Thanks for any input.

[June7]

Better would be to prevent the error.

If Me.Dirty Then
DoCmd.RunCommand acCmdSaveRecord
End If

or

If Me.Dirty Then Me.Dirty = False

Record entry/edit is committed to table when move to another record or close table/query/form or run code.

Why do you need to save record just because control loses focus?

[ItsMe]

I would probably use the PurchasePrice_AfterUpdate.

Also, you can check if the Value of PurchasePrice is Null.

I think something like this would work ...

Private Sub PurchasePrice_AfterUpdate()

if isnull(Me.PurchasePrice.Value) = False then
DoCmd.RunCommand acCmdSaveRecord
end if

end sub

[Abacus1234]

Thanks for the suggestion. Under some circumstances the form stays open as a reference to other forms being opened. I do not commonly move to another record.