I've read through the archives trying to find a solution to my problem. I've seen several messages that seem like they should have addressed my problem, but nothing seems to work.

I'm trying to ZAP a table. The only way I could get to work was to close my two free tables, reopen them exclusive and then ZAP the one in quesiton (I had SET EXCLUSIVE ON statements all over the place but they did not seem to work). However, after the ZAP when the screen is repainted one of my two grids (the one holding the table that is NOT ZAPped) is blanked out. No grid, no columns, just a big white box. The other grid looks fine. The table is cleaned out and it refreshes to look like it should. Here is my code:

lcSameSource = Thisform.grdDataTable.RecordSource

CLOSE TABLES
use /data/cross.dbf EXCLUSIVE
use /data/outtable.dbf EXCLUSIVE

Thisform.grdDataTable.RecordSource = lcSameSource

lcRecordSource = Thisform.grdOutTable.RecordSource
Thisform.grdOutTable.RecordSource = ""
ZAP in outtable
Thisform.grdOutTable.RecordSource = lcRecordSource

I thought maybe by "resetting" grdDataTables RecordSource (this would be the blanked out grid) that it would refresh properly, but it does not.

any ideas?

TIA