Couldn't get it to work, Bruce ... I'm going to give Ed's suggestions a try now.
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.