I have a form that updates records in a table.
I use an sql query to open a Recordset and I use Recordset.Update to update the fields in the table (when user presses the save btn).
I use a generic btn to close the form. When I use this btn it automatically saves a duplicate entry into the table. How can I prevent this?
I converted the btn to vb and tried to use a msg box to prmpt user if they want to save (update record) but I am not really sure what DoCmd.Close actually does. How can I close the form without it saving?
I am new at coding with Access so I apologize in advance.
Thanks
I use an sql query to open a Recordset and I use Recordset.Update to update the fields in the table (when user presses the save btn).
I use a generic btn to close the form. When I use this btn it automatically saves a duplicate entry into the table. How can I prevent this?
I converted the btn to vb and tried to use a msg box to prmpt user if they want to save (update record) but I am not really sure what DoCmd.Close actually does. How can I close the form without it saving?
I am new at coding with Access so I apologize in advance.
Thanks