I have a simple grid on a form. The RecordSource is a file called 'purge.dbf'. I am trying to use the same grid and same form to display 2 differents sets of data (same table and table structure). I create the table initially on load (calling a user method). It is created via a SELECT - SQL command using INTO DBF 'purge'. I then alter the table to add an additional logical field. This field is represented by a checkbox on the grid.

Once in the form the user should be able to toggle between two different sets of data (again, with the same fields just different data) by using a graphical radio button.

Now everything works fine of the purge table is static and I open it on load. The grid captions are correct and the checkbox appears on each row. But, when I use the select method the columns lose their headings and the checkbox is no longer there although the field that it represents is.

I know this has something to do with the recordsource but I have not been able to figure it out. In general terms, I take these steps:

1. Select the data into a dbf (which is the recordsource of the grid).
2. alter the dbf adding a logical field
3. refresh the form and the grid recordsource:

WITH THISFORM
.REFRESH()
.Grid1.RecordSource=THISFORM.Grid1.RecordSource
ENDWITH

Any ideas what I am doing wrong?

TIA,
George