Duplicate records

[qureshi]

Hi,
I have a form for data input. When the users enters the data in the form, and clicks on the ADD button, the record is saved.
When he is done with data entry, the user clicks on the DONE button to exit the form. This duplicates the last record.
Is there a way to get rid of the duplicate records programatically.

Thanks in advance
Qureshi

 

[Binnit]

If you post the code behind each of the command button events, it might help to clarify what is happening for each control.

If IT ain’t working Binnit and Reboot

 

[JoeAtWork]

I'm guessing you are using a bound form, which would automatically save the record when the form closes, while the code behind the Add button is saving the record using "screen scraping" to get the values to write to the database.

If that is the case, you should choose one method or the other, i.e. either automatic binding or make the form unbound and write your own code to add, save changes, and delete records.

Of course, this is just a hunch until you can post your code, and tell us if the form is bound to a table or query.