This may be a silly question but I have a sub that loops thru each record in a table & either updates some fields if some conditions are met or moves on to next record. Criteria is somewhat complicated & based on select case statements of several fields. Problem when I was testing was that if there was an error, code broke, I fixed problem, but then could not continuse loop thru-Error Message,'Can't got to next record in design view". This meant I had to reset my table to original values & start over each time. Is there a trick to getting out of VBA & yet continue the code?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Debug when looping thru table
- Thread starter Chrisbi
- Start date
- Status
Similar threads
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question