View Single Post
 
Old 06-12-2014, 02:12 AM
macropod's Avatar
macropod macropod is offline Windows 7 32bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,363
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

No, it should say 'Exit For', as posted.

When you get the error message, does the popup display a 'debug' button? if so, what code line is highlighted? Also, if you hover the mouse over the 'i' in '.ActiveRecord = i', note the number then check the corresponding row in the data source (which should be one more than the 'i' value). Check whether that row has data and whether there is anything materially different about the data on that row from the other rows.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]