Hi Roi & Barbara,
grid1.column1.controlSource has already lost its setting on GRID.INIT. I can programmatically change the controlSources at that point and get it to function properly.
At this point, I have greatly simplified the form. The files are being opened in the data environment, and I've removed almost all of the controls and code. The only code in FORM.LOAD is a 'set confirm on' and a 'set procedure ...' statement.
I'm trying to use the debugger to find out exactly when the controlSource property is changing. I have not been able to get the debugger to break on a change to that property.
Barbara, if I don't get this figured out, I may just have to send you the form to have a look.
Thanks a lot...
>Hi Steve,
>
>This is a swag but I think the grids source is getting ripped out and then put >back in place. If a grids recordsource is closed while it is instantiated it >will lose all it settings. If the recordsource is then reopened the only thing >the grid can do is default to the order of fields in a table. It's a common >problem if you don't that happens. The easy fix is to set the grids >recordsoucre = '' close the table, reopen the table and then reset the >recordsource.
Steve Gibson