>It was recommended that to keep a grid from crashing when I delete the table's records and refill them with new ones... I should:
>- use COPY STRUCTURE to create a temporary file with proper structure
>- change the grids RECORDSOURCE to the new structure
>- change the grids columns CONTROLSOURCE to the new structure
>- change the delete the old source file and recreate the data
>- change the grids RECORDSOURCE to the recreated file
>- change the grids columns CONTROLSOURCE to the new structure
>
>How do you change the CONTROLSOURCE... I tried thisform.grid1.columns(1).controlsource= and I get an error of unknown item.
To keep grid from crashing:
thisform.grid1.recordSource = ''
Then recreate the recordSource (delete the records, or do whatever), then reset the controlSource setting:
thisform.grid1.recordSource = 'whatever is was to start with'
I don't think all the steps listed above are necessary.
HTH,
Steve Gibson