>I have a grid in a form based on a veiw (from SQL server) - when the view is updated (to a new record) the gird blanks out (turns into a white square on the screen). I have tried to refresh the grid with no luck. Anyone have any ideas????
>
>
>Thanks
Do you mean that grid blanks out after Requery("view")? Normally, it should be so, but you can always fortify your code by issueing:
Thisform.Grid1.Recordsource=""
Thisform.Grid1.Recordsource="view1"
This way may involve additional coding if you have specific column settings and usually is not required for views, but it's still a way.
Edward Pikman
Independent Consultant