<div>
'Me.Filter = &quot;&quot;&nbsp; &lt;-- this line is not necessary<br />
Me.FilterOn = False<br />
&nbsp;<br />
reading more...<br />

</div>


'Me.Filter = ""  <-- this line is not necessary
Me.FilterOn = False
 
reading more...


<div>
<div class="content wysiwyg-content">
Hi Experts,<br />
<br />
I have a problem that causes me a headace :p<br />
<br />
I have a form which I have attached a command button to. When command button is clicked the form is set to FilterByForm (or actually I re - open the same form and go to FilterByForm). When I go into FilterByForm I want the FilterByForm to reset and display no values (only headings). However, this is not the case.<br />
<br />
This is the code I use:<br />
¨<br />
Private Sub .....<br />
DoCmd.OpenForm &quot;Personal Information&quot;, acNormal, &quot;&quot;, &quot;&quot;, acNormal<br />
DoCmd.Maximize<br />
Me.Filter = &quot;&quot;<br />
Me.FilterOn = False<br />
DoCmd.RunCommand acCmdFilterByForm<br />
<br />
End Sub<br />
<br />
Please suggest me how to solve this?<br />
<br />
Best regards,<br />
<br />
KO
</div>
</div>


Hi Experts,

I have a problem that causes me a headace :p

I have a form which I have attached a command button to. When command button is clicked the form is set to FilterByForm (or actually I re - open the same form and go to FilterByForm). When I go into FilterByForm I want the FilterByForm to reset and display no values (only headings). However, this is not the case.

This is the code I use:
¨
Private Sub .....
DoCmd.OpenForm "Personal Information", acNormal, "", "", acNormal
DoCmd.Maximize
Me.Filter = ""
Me.FilterOn = False
DoCmd.RunCommand acCmdFilterByForm

End Sub

Please suggest me how to solve this?

Best regards,

KO

Filters do not reset in FilterByForm mode

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.