Deleting unneeded records

[Dinger_80]

So I have a bit of an interesting situation. I created a database to track test requests from engineers. They fill out a form and things work from there. Well to increase the speed of them inputting requests, because some are virtually the same, with the exception of one item, I use a a copy record query. This works fine because after I run that I run an update query that changes the information that needs to be changes. Even this works just as planned.
My issue is that sometimes the user creates one too many requests. So the last copy query isn't needed. What I would like to do is somehow when they leave the form or access is to delete the unnecassary record. It doesn't come up as a new record and since nothing has been changed the form ins't dirty either. That has left me wondering how to check if this record is meant to stay without asking the user.
I certainly have methods at my disposal that I can use along with interations from the user to get the results I want. I am just trying to avoid this if I can. I am just wondering besides checking if its a new record or if its dirty what other options do I have, if any?

 

[MarkK]

Whether a record is valid or not is a test you'll have to do using the data in the record. There is no way other way.

How does it come to your attention now that one of these offending records exists? The criteria you use now to recognize one: that is the criteria you'll need to use. What is that?

 

[Dinger_80]

I have been using different methods to make sure there is never a duplicate record. I recently changed how my form works. I used to manually update the form and run a delete query when exiting out of the form or access. It wasn't a full proof method, sometimes one would slip through. Friday when I was at work, I watched a guy put in too many requests (added an unnecessary record). I was hoping it was deleted but it wasnt. Thankfully, I don't have a duplicate record. So what I am going to do is, I have a check box for when a user submits a new record and check if that is true when they exit the form. I will be mindful to only ask so long as it's a record that may look out of place. Users can fill out a record and save it for later or they require another users to finish filling out the form. I guess it sounds harder than it is. Truthfull, if it's not a new record and it's not dirty, 9 out 10 times it's an unnecessary record. Not too many reasons that situation should ever occur.
Thank you for your help.