Hi,
I am trying to decide if I should use a delete button or delete query to delete a record. I only want the users who knows the delete password to delete the record. there are many tables linked to the "account table" and I want to limit the users who can delete. There will be times that users will probably create the wrong account due to typo, and needs it to be removed from the database. in those cases, they will need to notify the manager and then manager will go in to delete the record.
should I create the delete button with password vba code next to the sub-form records? or should build a separate form using delete query where manager will have to enter the account number and then hit delete? the separate form of course will be under the Admin navigation page, so only users with admin rights will have ability to see this delete form.
Any feedback is greatly appreciated!