View Single Post
 
Old March 24th, 2006, 01:33 PM
arfa arfa is offline
Registered User
 
Join Date: Mar 2006
Location: Ventnor, Isle of Wight, United Kingdom.
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default 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'"