I have split form/single table using Access 2007. A delete button was added that deletes certain records based on criteria. After deletion the records show "deleted" in the lower pane. The Me.Refresh method will not clean up the lower pane. From the ribbon you can select "Refresh All" and like magic the lower pane is clean. How may I execute a "Refresh All" using VBA?