<div>
try this:<br />
DoCmd.RunCommand acCmdCloseWindow<br />

</div>


try this:
DoCmd.RunCommand acCmdCloseWindow


<div>
<br />
DoCmd.RunCommand acCmdRemoveFilterSort
</div>


<div>
Closed, 500 points refunded.<br />
Vee_Mod<br />
Community Support Moderator
</div>


Closed, 500 points refunded.
Vee_Mod
Community Support Moderator

<div>
<div class="content wysiwyg-content">
When you click on the Filter by Form toolbar button, the active form changes to filter-by-form view. If you then click 'Close' on the Filter/Sort toolbar, the form reverts to normal view.<br />
What is the code equivalent of clicking 'Close' on the Filter/Sort toolbar? <br />
I've tried<br />
&nbsp; &nbsp;DoCmd.RunCommand acCmdClose <br />
but I get <br />
&nbsp; &nbsp;Error: No current record.
</div>
</div>


When you click on the Filter by Form toolbar button, the active form changes to filter-by-form view. If you then click 'Close' on the Filter/Sort toolbar, the form reverts to normal view.
What is the code equivalent of clicking 'Close' on the Filter/Sort toolbar? 
I've tried
   DoCmd.RunCommand acCmdClose 
but I get 
   Error: No current record.

How to close Filter by Form view using code

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.