We must go through very large data sets, i.e. 100,000 to 200,000 records, each of which has many data fields. Among those fields there are 21 that we may want to flag for needing data, i.e. not zero or null. It may be that only 1 in 50 or even 1 in 1000 records have problems, so we don't want to chug along one record at a time.
So in my Current event I check all these fields will result in a record needing updating and if they're all good then I want to skip to the next record, otherwise I want to stop.
Everything essentially works except it tends to crash after skipping many records, and when it get's to one where I want it to stop, i.e. I don't even execute the statement that sends it to the next record, instea of just stopping it crashes there saying t can't go to the specified record.
The statement I'm using is:
DoCmd.GoToRecord acDataForm, "Accident Picker", acNext
Also, sometimes it says there's not enough memory to go on. This is usually after about 100 records have been skipped. Is there an easy way to do this that's not so unstable?