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'"

Try this before your docmd.runSQL

DoCmd.SetWarnings False

then just before the end add:

DoCmd.SetWarnings True

This tells Access to tuen off those message boxes and then to turn them back on when you run this procedure.

Wes E.

Or use:

CurrentDb.Execute "UPDATE tblUser SET [User] = Forms![AddHrsPwd].[cboStaff] WHERE tblUser.[ID]='1'"

No message boxes, no need for DoCmd.SetWarnings

Bob