Cancelling a record when its been half entered.

[Guest]

How can you cancel a record from within a form after the user has already
entered half the information. Ex. A person is entering a record and after
most of the information is entered decides they don't want that record
entered. I've looked at the undo but that doesn't eliminate the record. Do
I need to do a delete row command with the key in the where clause.

Thanks for any help

Tom

 

[AlCamp]

CDTom,
Sounds like that's the way to go.
Probably somewhere along the way to filling out half the fields, an
update was done, so the Undo can't get rid of everything.
Grab the key value, move to a new record, and run the delete query.
hth
Al Camp

 

[Guest]

Thanks for the reply, but when I do the delete the form shows #delete in all
the fields. It is working but I don't want to have the user see this. Is
there a way to eliminate the #delete from showing.