>>I have a form based on a main table that, through various methods, performs functions using other tables. My problem is that when I perform a function on another cursor (count, replace) the main table goes to eof(), and all the fields go blank. There is no seek code on that table except for in the form's init event. I don't even exlicitly issu a select anywhere... all functions contain the name of the table alias that they are performing on. Through debugging, I have found that the main table stays in the selected area. What is causing this table to lose its record?
>>
>>Erik
>
>I think this is one of those "undocumented features", and in some cases it is a documented "gotcha". If you were to select the specific work area you wanted to perform a function on (somewhere off the main table), then execute the function, your main table pointer will stay put. If I understand correctly, you are not selecting the workarea you are performing the function on.
>
>HTH.
Thanks Mark! That did it.