UPDATE MyTable set MyField = 'MyNewValue' where KeyField = MyRecordID