>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).
If it's not broken, fix it until it is.
My Blog