Bruce,
1) If I set the grid.recordsource to "" before modifying it & then reset it back afterwards, will I need to reset all it's other properties (as Ed alluded to in his reply)?
2) OK, time for me to wake up and smell the OOP :) I haven't had the experience of using views yet, what's involved with doing that? what are advantages and disadvantages?
Thanks,
Bonnie
>>I can't seem to find a Requery method for grids, but it almost seems that I need to have such a method. I've got a grid based on two related tables, one of which is created in a form-scoped method with a SQL SELECT. When the screen is first activated, all is fine. But as soon as I call the method that re-creates the one table, the grid disappears ... it's obvious why this happens (because the table is deleted and then recreated) but now I need to know what to do about it. Any ideas anyone?
>
>For this you could do a couple things:
>
>1) Before modifying your tables, set the grid.recordsource = '',
> then reset it afterward...
>2) Change to a view and use the Requery() for it.