RunSQL Method Example

The following example updates the Employees table, changing each sales manager's title to Regional Sales Manager:

DoCmd.RunSQL "UPDATE Employees " & _
    "SET Employees.Title = 'Regional Sales Manager' " & _
    "WHERE Employees.Title = 'Sales Manager';"