I have two command buttons on my form, and one works the way I want while the other works but not as well as I want.

This is the Deny button, which effectively removes the record from the set:


This is the Approve button, which does it's job by sending the information to another form to be edited, but does not remove the approved form from the query results.


The approve button should remove the approved record from the form, but it doesn't. Any suggestions on how to fix this?

instead of using the query to filter, use the form filter

me.filter = "ECRReviewed = 0" 'AND whatever else you are filtering
me.filterOn = true

Thank you very much. After changing that part it works just fine!

you're welcome happy to help