VBA String to delete current record 1

[Zycmi]

I've got form that has a nasty knack for creating a record with no information in it due to the fact that a user will select an item from a combobox then close the form. This throws off the totals and is unacceptable due to the fact that this database was created to take statistics.. I have decided to put code into the Form_Close section of the form, though I can't figure out the code to delete the current record before closing the form, without a confirmation message. Can anyone help?

Thanks in advance
Zycmi

 

[idono]

Zycmi,
You are in luck my friend! I had the same problem today and found this. Me.undo will remove whatever was entered from the table (ie. blanks, partial fills)

Me.Undo
DoCmd.Close

Dugger