Would like to update all the values in a table (tOffice) to False (-1) for the field name "Courier"
I've tried some variations of this SQL command without luck
DoCmd.RunSQL "UPDATE toffice SET Courier = -1
Courier is a yes/no variable.
What is wrong with my syntax? Should I be using an SQL update for this?