>Grid problem...I set my grid column recordsource during design, set bound to .t. and set text1 to same recordsource as the column. the recordsourcetype for the grid is set to an updatable cursor and recordsourcetype is set to 1(alias). before I run my query i set the recordsource to "" then run the query and create the updatable cursor then set the recorsource to "mycursor" to retain grid formatting I worked so hard setting up. The formatting of the grid stays intact, but somehow my recordsource for my grid columns is getting changed and displaying fields in the grid incorrectly. I looked in the debugger for the recordsource for the grid columns and somehow the columns recordsource is getting changed to another field name of the cursor. Any ideas as to what is going on?
>
>Any suggestions greatly appreciated!
>
>john.
I have not tested it, but as in design mode, if you assign recordsource to the grid, it automatically assign the recordsource to every column in the grid in the order of the fields in the cursor. You must change your select query and place the fields in the order you want to appears in the grid. Or assign programatically the recordsource of each column after the grid.
Carlos.
Saludos,
A.G.P.
---------