>>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
Hi Nick,
Thanks for responding.
When I set the controlsource do I set it for the column, or the active control for the column i.e(textbox,checkbox etc.)?
Thanks,
John.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only