>On a form, I have a button that does an SQL select into a cursor. I then create a grid using AddObject. The grid displays the the cursor fine. But if I do another SQL select to the cursor using the the same name, then do a refresh on the grid it shows up with a column count of 0 and the display is blank.
>
>I don't understand why this doesn't work if the grid constrolsource still shows the cursor name.
Kevin,
try to do like this:
ThisForm.Grid1.RecordSource=""
*do your SQL select
ThisForm.Grid1.RecordSource="CursorName"
Regards
Alex