Error msg: Shift must be 1 or 2 or 3 or 24

[chuckgoss]

Hi all...
In access 2000 I can't get past this error on one form. It is trying to update a table by incrementing to a next record, doing some things, and going onto the next record till it runs out of records. I haven't been able to find it is searches here or in access help either. Any definitions about it or what it means?
Thanks in advance

chuck

 

[Pat Hartman]

Although you can do what you are trying to do it is somewhat like trying to fit a square peg into a round hole. Forms are intended to be interactive and deal with one record at a time. They are not the normal place to put code that will process an entire recordset at one time. You might have more success if you moved your code to a standard module.

Frequently the best way to update a number of records as a group is to use an update query. The update query is almost always faster than a VBA code loop to do the same thing and certainly easer to write and test.