>>we have a screen in vfp5 that we want to have a grid and a button under it. When the user pushes the button, a sql statement executes and the grid should fill with data. We see the data is pulled in on the status line but it does not populate the grid. If we manually run the sql before the screen is run, the grid is populated....Refresh doesn't seem to get it. Am I missing something here? I thought REQUERY was the answer but it does not seem to be for grids.
>
>Ed, when you re-run SQL your grid looses RecordSource. You have to reset record
>source after SOL, but in general it is better to use a view as grid.RecordSource, REQUERY(), and grid.Refresh()
>
>HTH,
>
>Nick
Thanks for the quick answer. I really appreciate it!

Ed