Deleting Record From Table

[WackyWaterGuy]

HI everyone! Just a really quick (and hopefully a simple) question for you! I have a combobox linked to a table which displays a bunch of names. What i would like to do, is have the ability to select a name from the combo box, and delete that record from the linked table. I have been trying to figure it out for a while, and have been going around in circles. Any help that anyone can offer would be greatly appreciated. Here is the code i have been working with thus far...although it hasnt gotten me too far!

Option Compare Database

Private Sub Delete_User_Click()
On Error GoTo Err_Delete_User_Click


DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70
DoCmd.DoMenuItem acFormBar, acEditMenu, 6, , acMenuVer70
DoCmd.DoMenuItem

Exit_Delete_User_Click:
Exit Sub

Err_Delete_User_Click:
MsgBox Err.Description
Resume Exit_Delete_User_Click

End Sub


Please help!

Thanks

WWG

I looked at the code again that Access defaults and this works fine, but I want to be able to delete a specific record from the table specified in the Combo Box. Sorry guys, I don't really understand the syntax very well and the Access help is not really any help.

Thanks again

 

[ahemr]

Have you thought about using the Docmd.RunSQL function, and creating a delete query in SQL format? If you are unfamiliar with SQL, you can create the query in the normal Access query design view, then view the SQL format of it, copy that text into the docmd.runsql function and you're set!