Delete Selected item in a ListBox

[Trinb37]

Hi,
Is there anyone who can help me to modify this code so that it would delete a "Selecte Item" off a listbox.
Private Sub Command2_Click()
On Error GoTo Err_cmdDelete_Click
DoCmd.RunCommand acCmdDeleteRecord
Exit_cmdDelete_Click:
Exit Sub
Me.List0.Requery
Err_cmdDelete_Click:
MsgBox Err.Description
Resume Exit_cmdDelete_Click

End Sub

the code is deleting information from the table but not by order of selection. Thank

James

 

[dcx693]

Do you want the item just removed from the listbox? Or also from the table?

 

[mr moe]

How do you delete it from the table?

Thanks.