>I've got a parameterized view which has table buffering. There are basically four fields that make up this table. I have four text boxes that when filled in are reflected in the grid. I can also add and delete based on what row is selected in the grid. The grid itself is read only.
>
>When deleting, at first, I was not getting any refresh of the grid. Then I was told of the trick to set the grid's record source to itself. This worked but the column control sources which are set in code were now incorrect.
>
>I then attempted to call the method which sets the control sources but unfortunately the grid again was not updating properly. Only when all records are deleted does it show an empty grid as it should.
>
>What am I forgetting?
How about a grid.setfocus after everything else? You can bouce the focus back somewhere else afterwards, if you need to...
The Anonymous Bureaucrat,
and frankly, quite content not to be
a member of either major US political party.