View Single Post
 
Old March 24th, 2006, 08:05 PM
Bob Bedell Bob Bedell is offline
Friend of Wrox
 
Join Date: Jun 2003
Location: , , USA.
Posts: 1,093
Thanks: 1
Thanked 12 Times in 11 Posts
Default

Or use:

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

No message boxes, no need for DoCmd.SetWarnings

Bob