I am trying to update a table using a value from a recordset using an update query as follows

DoCmd.RunSQL "UPDATE BookKeywords " & _
"SET BookKeywords.KeywordID = '" & rst.Fields(0) & "'" & _
"WHERE BookKeywords.KeywordID = '" & Oldkeyword & "';"

The value in rst.Fields(0) looks like the correct key value (40) when I put a watch on it, but the type of this field in the watch is variant/integer. I get a data type mismatch when this sql is performed. I've tried to convert the value using the CInt function but it still shows up as variant/integer in the watch window.

Please help me!!!
Ryan