>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

Maybe you have temp relationships.