• Registered: 2017-06-23
  • Posts: 50

Topic: Record save double

Hello
When I Create a <save> button and it is running, the record is saved, but I press it again, the record is saved twice.  What can I do to fix that?

  • derek
  • derek
  • Moderator
  • Offline
  • Registered: 2015-02-16
  • Posts: 2,674

Re: Record save double

Hi,
This usually happens if you do not close the current form after saving;  closing the form is the easiest way to prevent this from happening.
However, if you need to keep the form open after saving, you can clear the fields (with a script);  you should also set one or a number of the form fields to be mandatory (to prevent  further problems with blank records being created).
Regards,
Derek.

  • Registered: 2015-11-13
  • Posts: 652

Re: Record save double

You can also place the following inside the Save button OnClick event to stop it from saving another new record. Any subsequent field changes on the form will update the newly created record only.


 Form2.SaveButton.dbDontResetID := True;
  • Registered: 2017-06-23
  • Posts: 50

Re: Record save double

Thanks