Removing the MsgBox in DoCmd.RunSQL Update
I have the following line of code and it works fine, apart from the warning message box that keeps appearing informing me that I am about to update 1 Row.
How do I stop the MsgBox appearing and prompting for a response?
DoCmd.RunSQL "UPDATE tblUser SET [User] = Forms![AddHrsPwd].[cboStaff] WHERE tblUser.[ID]='1'"