>>I'm converting some dbf's to SQL Server tables.
>>In several cases, I have to replace the dbf as a recordsource of a grid with a cursor created by reading from a SQL table.
>>I set the cursor name as the recordsource property of the grid, set the column names as the controlsource properties of the columns.
>>When I show the form instead of showing the named columns column1 in the grid shows the contents of column 1 in the cursor, etc, etc.
>>As a workaround, I changed the query so that things work, but that will not work in every case.
>>Any ideas?
>
>BTW, I always use AliasName.colName for control source and not just colName. We had some problems with the latter technique a while while back (in 2003, I think).
Yes, that's how I do it also.
Anyone who does not go overboard- deserves to.
Malcolm Forbes, Sr.