>I have a pageframe with 10 pages on it. The first one has a grid with records from two related tables. I can cycle between most pages and return to page 1 but when I return from some pages the data does not display. I know it is there as I have placed a listbox with the same data on page 1 and it displays the data ok. Is there a special 'refresh' command for grids?
>
>Hope I have given enough info, can omeone can help.
>
>Thanks Rob Cole
Grids have bad habit to lose data when you touch its recordsource. For example, if you base a grid on a cursor and re-populate the cursor with Select-SQL. Also, it may be the result if you pack a table, requery a view etc. The general remedy is to restore Grid.Recordsource programmatically:
Grid.Recordsource=''
Grid.Recorsource='mycursor'
In many cases, it's not enough. You may also have to restore Columncount property and Column.Controlsources and may be something else.
Edward Pikman
Independent Consultant