>>If you haven't tried removing the grid recordsource completely and then re-setting it, that's another idea...
>
>Remove the recordsource? That'll mess up the grid. I don't want to have to rebuild it in code.
No, it shouldn't mess up the grid. Just do
grid.recordsource = '' (empty string)
set filter, etc
grid.recordsource = 'mysource'
The Anonymous Bureaucrat,
and frankly, quite content not to be
a member of either major US political party.