>Actually, Wayne, as I sit here thinking about it, I'm coming to the conclusion that this is not a very possible goal. I thought of adding a Timer control to set the grid's RecordSource to .NULL. and then re-select the table, but it would be a nightmare trying to enable and disable the timer for every keypress, SKIP, button click, etc.
>
>Now I have to break this wonderful news to my boss.
>
>Henry

See the REQUERY() function, if the Grid's record source is a SQL view (note, don't confuse this with the REQUERY() method of a ListBox or ComboBox).

Also see the SET REFRESH command, which is responsible for refreshing cached data. You should not need to play around with the Grid's RecordSource - typically doing so, will also remove all column binding details, this will blank the Grid, and when you re-establish the RecordSource the columns will revert to the first n columns of the data source.

You might need a timer event that calls the Grid's REFRESH() method.