My Delete SQL will not work

[NewfieGolfer]

I have the following code:

Private Sub

Dim key as string
Dim Lst as control

Lst = Me!list1

key = Lst.Column(0)

docmd.RunSQL "DELETE * FROM Table WHERE Field = " & key & "

End Sub


When I run it it says there are no rows to delete, but the key string contains a value and that value is in the Table. Can anyone see what's wrong here.

BTW, this is in a listbox dbl click event.


Thanks,

NG

 

[petermeachem]

Did you mean key string.
If so do

docmd.RunSQL "DELETE * FROM Table WHERE Field = '" & key & "'"

Peter Meachem
peter@accuflight.com