I am getting the following error on Line3:

ADODB.Recordset error '800a0e7d'
The connection cannot be used to perform this operation. It is either closed or invalid in this context.

Code is:

Line1: sql = "DELETE FROM tblPushLoc WHERE ID = " & ID
Line2: Set objDel = Server.CreateObject("ADODB.Recordset")
Line3: objDel.Open sql, objConn, 3

I am trying to update a table by add/or delete checkboxes on a form.

Any ideas???

Is the error message correct? Maybe your forgot to open the connection??

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.