John,
When you indicate that you are creating an updatable cursor are you referring to a view. If so, is just your
record selection changing or are the base tables to the view changing. If it is just the
record selection you do not have to change the recordsource.
=================================
>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.