Try setting the grids recordsource property to '' before doing any manipulation of the table its based on. After you are done changing things, set it back to your tablename.
>This is i problem I have been fighting with for a very long time and newer got any good solutions... When i'm working with a grid I often create a temporary table (in dataenvironment.beforeopentables) which I edit in grid. So far so good. The problem is when i'm moving around in the "real" table and need to update my temporary table with new records. My forms refresh method looks something like this:
>
>select tempgridtable
>zap
>select realtable
>scan for....
> insert into temptable ....
>endscan
>
>If any object except the grid has the focus when i'm doing form.refresh() everything is fine and all the records shows correctly. But if the grid has the focus then the grid becomes empty. Why?
>
>The problem only seem to occurs when grid.RecordSourceType = 1 (Alias)
>
>Can somebody help me out here?
>
>/Mårten Törnquist
--Todd Sherman
-Wake Up! Smell the Coffee!