delete row from table

[BPBP]

Hi,

I have a form where the user keys in all the fields. After keying in, there is a button to close the form.
As access autosaves the values into the table, in the event the user decides to leave without saving the record. Is there a command where I can input into the event of the "leave without save button" whereby the entire last record(row in table) that is currently being keyed is automatically deleted without warning.



Thanks.

BP

 

[missinglinq]

Me.Undo will undo a record that hasn't been saved.

 

[BPBP]

Me.Undo will undo a record that hasn't been saved.

Thanks, I tried, it undos the controls, but does not delete the row in the table. My form is set as dataentry, Hence if i add a new record, the previous undo'd record will still be there, with fields all empty except the autonumber field still around.

oh i just found, there is the control wizard can make a delete record button and used its code. thanks anyway