Unanswered: Delete a record. "asking for simple procedure"
Hello everyone. I want to delete a record in a database "Employees" using the employee number. I tried to use an action query "Delete" and run it using a command button but the command button wizard does not recognize the query. "It does not show its name in the list of queries". On thing i also tried was writing a macro to run the delete query but it did not work even thought the macro appeared on the list of macros.
I need a simple way of asking for the badge numbe to be deleted and delete the coresponding record from my update employee form.
Note that i am an access beginner but i am learning alot by the minute !
Thank you very much.
you have delete query delQry and a button YourDeleteButton
private sub YourDeleteButton_Click()
docmd.setwarnings false 'optional - will block "are you sure" messages
docmd.setwarnings true 'reinstates "are you sure" messages if turned off