Refreshing a split form is not working

[Pack10]

I have a split form that is filtered where the the user selects a record to update a status. This opens a form with all the fields. When the status in the record changes, it should not be listed in the split form (grid) anymore, but I cant seem to get the refresh or requery to work right;

Now, the split form has a command button that does a me.requery
and that works fine....what I want is after the record is updated with the new status, I dont want to see it in the split form grid.

 

[Pack10]

I put in the form activate property me.requery and it
seems to have solved the issue.