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

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.