Forms
Admin Menu - ButtonName: Delete Employee (calls Delete Menu and runs query to populate dropbox)
Delete Menu - Dropdown box populated with Employee's name (field 0) and Employee'q ID (field 1)
Administrator selects Employee's from dropdown list to remove
ButtonName: Delete Button call OnClick event
OnClick event MsgBox displays selected Employee name and ID.
DESIRE TO DELETE THE ROWS FROM THE DATABASE and RETurn CONTROL BACK TO
DELETE MENU.
In Access I created a delete query and can manually remove the data from the database.
Is there a way to execute this query from VBA to remove the row in the database?
Thanks