How to delete a new, incomplete record programatically.

[ogg13]

Lets say that you have a form, using a table as a recordsource, that a user enters data into from a series of blank textboxes.

After they enter the first bit of data, they click a button to save the record and go to a new blank record.

Next, information that will most likely be used for the next bit of data entry is programatically populated into the appropriate text boxes.

At this point in time, access populates the underlying records fields with the data that is carried over from the last bit of data entry.

Now, the user has two options:

Continue with the data entry, modifying or adding information that didnt carry over.

*OR*

Click the close button on the form and go about their merry way.

In my access database, continuing on with data entry works just fine. However when a user tries to exit out, they are faced with a series of built in microsoft access errors in regards to key violations and not being able to save records.

Is there a way to delete the underlying, incomplete record when the user hits the close box, OR is there a way to remove these messages completely since they are expected as a form of a check to ensure that duplicate data isnt entered?

Thanks.

 

[RuralGuy]

The usual solution is to keep the user on the first record until it is completed, then deleting the 2nd record is simply Me.UnDo. A better mouse trap?

 

[ogg13]

Thanks for the idea and the link.. I believe this is exactly what I am after... Appreciated..