I have a grid on a pageframe on a form that displays a cursor. When the page it is on is activated, I rebuild the cursor and refresh the grid. But I do it by populating a "temp" cursor via a SQL statement, then zapping the cursor that the grid displays, then appending from the temp cursor. Unfortunately, the grid will sometimes show no data. All the columns are blank. If you click off that page and then back to it, it will display properly. Also, for testing, I put a button on the page that just refreshes the grid and if I click the button, then the grid will refresh and I can see the data. I've put refreshes all over the place (again, for testing) and even a DOEVENTS or two, but still this occurs.
I've also used the technique of changing the RecordSource of the grid to a cursor with the exact structure, saving the control sources of the columns, zapping and repopulating the main table, setting the RecordSource of the grid back to the main table, and restoring the control sources of the columns, all to no avail.
I should probably just change this to a view, but I use this technique in other projects without difficulty and it's irritating that I can't get this grid to display the data properly.
Russell