>I have a grid on a form that holds resultant data from a select into a cursor. I make the cursor updateable and then use this cursor as the recordsource for the grid. All works fine until a user grabs a header and moves that column to another position in the grid and then does another search. I've tried setting bound to .T. and setting the controlsource of the column and textbox to the correct field, but no such luck. The grid columns are still being populated by the cursor using the order in which the fields are selected in the select statement. For instance, if I move column 1(by dragging the header) to column 3, and re-query, column1 will be populated with column 3's field and not the field that I have placed in the controlsource for column1. Is there a way to (no matter where a user drags a column of a grid) make sure that the columns recieve the correct field from the cursor as its controlsource?
>
>Thanks,
>
>John.
John, you need to remember each Column.ControlSource and re-set them again after creating the new cursor.
Nick
Nick Neklioudov
Universal Thread Consultant
3 times Microsoft MVP - Visual FoxPro
"I have not failed. I've just found 10,000 ways that don't work." - Thomas Edison