>I have this form which has among other objects, a grid and a combo box.The combo box has the years "1996", "1997", 1998" etc and in the interactiveChange Method I do a select to a temp table a_temp where the YEAR(field_date) = 1996, 1997 etc as selected in the combo box.
>Thus the selection is made from the same table to the same named temp table.
>
>The grid is setup to display this selection.
>
>On the init of the grid when I do a select for 1996 the grid is populated. But when the next year (1997 or 1998) is selected via the combo box, the grid does not display anything although a_temp is present and populated with new data.
>
>I have tried the refresh method but cannot get the grid to display the new selection at run time.
>
>How do I achieve this?
>
>Thanks in advance
>
>Bernard

1) create your new cursor
2) set Grid.Recordsource = "(None)"
3) set Grid.Recordsource = "NewCursorName"

I think....