Update query based on a form

  • Thread starter Thread starter Brett
  • Start date Start date
B

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
 
Back
Top