>>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.

Hi carlos,

After futzing around for way too many hours on this, that's exactly how I did it. It would seem though that if I set the bound to .T. and set each individual columns recordsource to the appropriate field in the cursor, no matter what the order of the selects resultant fields, this should work...but I guess not. Just when I think I got the hang of it, I learn otherwise. Much appreciate your response and taking time to respond.

Thanks!

John.