That is perfect! Thanks a lot Rip!
>Before you do anything to the underlying data that drives the grid you have to set the grid's recordsource = '' . Then mess with the data, then set the recordsource back, or to another table.
>
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
Everything we see or seems
Is but a dream within a dream - Edgar Allen Poe