Recordset .update updating all rows?

[hdougl1]

My objective is select a row from a database based on the where clause. I'm getting back one row, but when I change the value that recordset and do a rst.update all the rows in the database are changed to that value. Here's the code.
Thanks a lot people this site is a good thing.
Henry

strSQL = "SELECT FADone, FADate, FADoer FROM Disposal_Detail WHERE Serial = '"& Trim(Request.Form("Serial&quot(m)) & "'"

rstDetail.Open strSql, objClassConn, 3, 3
rstDetail("FADone&quot = Request.Form("FADone&quot(m)
rstDetail("FADoer&quot = qualname
rstDetail("FADate&quot = Now()
rstDetail.Update

 

[hdougl1]

I found it you have to select the key field.