G
Guest
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
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