Bow. Bow. Salaam... You are right! :-) (But, I had to test it, I thought that zap would do a re-open of the table, but I was wrong. wrong. wrong.)
:-)
>Hi Todd.
>
>>> 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. <<
>
>Since Marten is zapping his temporary table, this bit of trickery is totally unnecessary in this case. It is only needed when you are closing the grid's recordSource either explicitly or implicitly (because you are, for example, packing the table). Since zap does not close the table, you don't need to do this.
--Todd Sherman
-Wake Up! Smell the Coffee!