Update query based on a form

[Brett]

I'm trying to create an Update query that will change move
a list of records under one contact to another contact.
To do this I need to change the Sequence number for the
one contact to the other contact. I can do it using one
record at a time but the user needs to be able to move all
the records at once. For some reason the Update query
either won't build or run. Thanks for any help, here's to
code if you want something to look at:

strSQL = "UPDATE dbo_tblCalls " & _
"SET dbo_tblCalls.cllFkCntSeqNum = " + Str([Forms]!
[frmEditCallHistory]![cmbNewContact]) & _
" WHERE dbo_tblCalls.cllFkCntSeqNum = " & _
Str([Forms]![frmEditCallHistory]!
[tbxcllFkCntSeqNum]) + ";"


Thanks,

Brett