Why won't UPDATE work? [resolved]

[bjawnie]

Hii,

Why won't this code work? I have been using it to update a datetime field without any probs., but know I get this error when I try to update the IP field:

Run-Time Error '-2147217887' (80040e21):

Set rs = New ADODB.Recordset
rs.Open "Select IP FROM m_members where id = " & struser_id & " ", conn, 3, 3
        rs!IP = Winsock1.LocalIP
rs.Update
rs.Close
Set rs = Nothing