<div>
The button is already there - below the datasheet: Filter.<br />
Just click it, and the filter is turned off.<br />
<br />
/gustav
</div>


The button is already there - below the datasheet: Filter.
Just click it, and the filter is turned off.

/gustav

<div>
Thanks, just perfect.<br />
<br />
(Much friendlier for the novice users of my system)
</div>


Thanks, just perfect.

(Much friendlier for the novice users of my system)

<div>
<div class="content wysiwyg-content">
I have a form that has a subform.<br />
The subform is a datasheet.<br />
The user can use the standard &quot;filter&quot; funtions in the datasheet.<br />
<br />
I need some VBA so that when I click on a button on the MAIN form ... the filters will be removed from the Subform.<br />
<br />
<b>How do I use VBA to remove all filters from the subform?</b>
</div>
</div>


I have a form that has a subform.
The subform is a datasheet.
The user can use the standard "filter" funtions in the datasheet.

I need some VBA so that when I click on a button on the MAIN form ... the filters will be removed from the Subform.

How do I use VBA to remove all filters from the subform?

Removing Filter from a subform  (datasheet)

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.