>I have a grid in one of three pages in a pageframe. The controlsource for the grid is a standard free table. When I click on the page that contains the grid, It is completly empty. I've tried refreshing the grid in the pages activate event method, but that hasen't solved the problem. Any ideas? I would also like to know what the syntax would be for closing a single table. For Example...
>Select 0
>USE products
>
>How would I just close the products table without effecting anything else I have open such as other tables or databases? Thanks in advance for any help anybody can offer.
>John Symons
Basically, you should restore grid if you made something serious with free table (e.g. open it when grid was already initialized). It means that you should again issue programmatically:
Grid.Recordsource="mytable"
Grid.Column1.Controlsource="mytable.myfield1"
etc.
To close a table, you may just say
USE IN products
Edward Pikman
Independent Consultant