recordset.open oConn,"SELECT * FROM table WHERE primary_key=" & pValueif Not recordset.EOF recorset.Fields(1).Value = "something new" recordset.updateend if