Hello Everyone,
I am very new to VBA. I was wondering is their a way to add an additional security step to a button that is places on a form?
I have a form with an append button on it. The button is used to add new records to a table that this form linked to. The issue is that if a user clicks on this button more then once the same records will be added to the table again therefore duplicate records will be added to the table. I would like to add a code that would prevent the user from clicking on this button for the second time to prevent this issue. Can this be done in access? If yes, Can someone please help me to write this code?
Thank you