Previous Thread

6/30/2006 10:31:02 AM    SQLRun - Silent update of field in another table? How?
I have the following code in an after_update event and it works fine. 
 
strSQL = "UPDATE PONumbers " & _ 
 
"SET PONumbers.Used = True " & _ 
 
"WHERE PONumbers.PONumber = " & Me.PRPONumber 
 
If Not IsNull(Me.PRPONumber) Then 
 
DoCmd.RunSQL strSQL 
 
End If 
 
However, when the Docmd command runs, the user is prompted with a Yes/no 
 
MsgBox to update the table. Is there a way I can do this silently so the 
 
user insn't prompted? 
 
Thanks



6/30/2006 1:53:39 PM    Re: SQLRun - Silent update of field in another table? How?
Previous to your DoCmd.RunSQL line, put 
 
DoCmd.SetWarnings False 
 
After it, put: 
 
DoCmd.SetWarnings True to turn the prompt back on. 
 
-- 
 
hth, 
 
SusanV 
 
"Tec92407" <Tec92407@discussions.microsoft.com> wrote in message 
 
news:3A85C54E-9E98-4753-8362-86CC32580796@microsoft.com...