This is what I've advised the person to do yesterday as you mention... look at all the tables in question... What he actually did was to make a copy of the form and started to remove all the other controls and its always hung on one in-particular.

What I think I'll have him do today is to "unbind" (clear the control source) of the combobox we THINK is the primary culprit, call the refresh, then re-bind (to the control source) and see if that helps.

Smoke and mirrors, but who knows... I've seen worse at times.



>This can be very difficult to pinpoint - this is basically a databinding error where one of the tables you are binding to has run out of the end of records and thus fails.
>
>I've never really found a good way to debug this either other than trying to isolate which table is causing it. The best thing to do if you can dupe it is to dig out the SET command and look at the cursor pointer in each of hte open tables. Most likely one of the tables will be somewhere it shouldn't be and hopefully this will allow you to backtrack.
>
>+++ Rick ---
>
>
>>Hi all,
>>
>>I was asked by another developer who has a problem in their system and can't track it down. He is getting an error during a Thisform.Refresh(). It has many grids and combo controls and such, and is getting an error "Record out of range".
>>
>>How can I tell WHICH control through the "Thisform.Refresh" is causing it... I've tried the event tracking, and set coverage, but nothing is showing as a result.
>>
>>Any ideas?
>>
>>Thanks