Updating multiple records

[Meg]

I just updated to Access 2010 and I'm having a problem adjusting. One of the features I built into my database form is code to update a field on GotFocus. This enables the user to review a text string based on the data fields they entered to, and it is also the field we use in the final report. (I first did this by a macro, but later updated it to code.)

In earlier versions of Access, if I needed to change this field for many records I would go to the table view and change the data fields and then go to the form view, put my cursor in the field with the GotFocus trigger and zip through all the records by holding down the Next Record button.

I've tried this in Access 2010, and holding down that button does nothing, so right now I have to click it to go to each record. Is there an option somewhere that would enable the press and hold, or a way I can run the code for all records at once? Or do I need to go back to my clunky macro? Or is there an easier way of dealing with this altogether? I've only had Access 2010 for a day, so I'm not even sure I can find where to make a new macro - still poking around.

Thanks for any advice!

[pdebaets]

Here's some simple SQL that you can use to update multiple records from a command button OnClick event procedure:

currentdb.execute "Update [MyTable] set MyField = 'ABC' Where MyOtherField = 'DEF';", dbseechanges + dbfailonerror