Delete the Last Record but Don't Create a New Record

[espua]

Hi all,

I want to allow my user to delete the last record (the record he just created) by using a command button with "DoCmd.RunCommand acCmdDelete". However, "acCmdDelete" will move forward to the next record, which in directly created a new record shall the command is perform on the last record. How do I get rid of this?

Help .......

P/S: Since my form contains another subform (like Order & Orderdetails type), therefore, I can not use the "Undo" command anymore shall there are some records in the subform.

 

[RuralGuy]

Have you tried setting the forms "Allow Additions" property to False?

 

[espua]

Hi RG,

Yes, it works, I just need to explicitly set the "Allow Additions" property to False before perform the deletion.

Thank you so much ..............

 

[RuralGuy]

Glad I could assist.