Simple DELETE doesn't work? 1

[Asspin]

What the heck am I doing wrong here?
strAlias is a global variable set on load.
I am getting "Run-time error '3464': Data type mismatch in criteria expression."

DoCmd.RunSQL "DELETE * FROM tData WHERE sName = '" & strUserName & "' AND iRow = '" & lstStart.ListIndex + 1 & "';"

Dan

 

[PHV]

I don't know why you mention strAlias ....
Anyway, if iRow is defined as numeric in tData:

DoCmd.RunSQL "DELETE * FROM tData WHERE sName='" & strUserName & "' AND iRow=" & (lstStart.ListIndex + 1)

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Asspin]

Sorry, I had jsut renamed that variable!

That was the fix though. Thanks as always PHV!

Dan