Update Database on Lose Focus event

[sgroth]

I'm building a database to provide name and phone number information to 3 telemarketing reps and give them a form to record the information they collect on the call. The trick is that once one person has started a call with a particular lead, I don't want it to be visible to the other reps -- so they don't call the same person.
I've got the information and data entry set up on a single screen driven by a query that filters out any leads that have been called by any of the other reps (as indicated by the rep typing in his initials at the beginning of the call). However, the screen doesn't refresh the query unless you open or close the screen. To solve this I added a button that calls Me.Requery.
The problem I still can't resolve is that when a rep starts a call, the database isn't updated with his initials until after he moves on to the next record. So if another rep pulls up that same contact it will look like it's available to call. I want the record to be invisible to other reps as soon as any rep enters his initials. I've tried to set up a lose focus event on the initials field to update the database, but I keep getting a "Too few parameters" error.



Private Sub ISS_Initials_LostFocus()
CurrentDb.Execute ("update [call log] set [ISS Initials] = Me.ISS_Initials.oldValue where [call log].[acct num] = me.acct_num;")
End Sub

Thanks to anyone who can help.

[June7]

You have to save/commit the record to table before can be updated. A record is committed when form closes or move to another record or DoCmd.RunCommand acCmdSaveRecord. The inititals textbox is bound to field in table? Should not need the Execute and UPDATE sql method, use DoCmd instead.

Syntax for the UPDATE would have to concatenate the initials and acct_num criteria:
"UPDATE [call log] SET [ISS Initials]='" & Me.ISS_Initials.oldValue & "' WHERE [acct num]='" & Me.acct_num & "';"
Also, the parenthesis might not be needed, maybe even a problem.

[sgroth]

DoCmd.RunCommand acCmdSaveRecord worked like a charm!

Thanks for your help!