Im using the update statment to change some values in my DB

VB Code:
  1. SQLupdate = "UPDATE FILE_ID (ID1, ID2, ID3) VALUES (42, 34, 34)"

  2.  
  3. CN.Execute SQLupdate

My question is how do I select which record to update? I already have a recordset open at the record I want with this...

VB Code:
  1. Set rsFiles = Server.CreateObject("ADODB.Recordset")

  2. rsFiles.Open "SELECT * FROM FILE_ID WHERE ID1=23" , CN, 3, 3