• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 292
  • Last Modified:

Filters do not reset in FilterByForm mode

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
Me.Filter = ""
Me.FilterOn = False
DoCmd.RunCommand acCmdFilterByForm

End Sub

Please suggest me how to solve this?

Best regards,

1 Solution
Mike EghtebasDatabase and Application DeveloperCommented:
'Me.Filter = ""  <-- this line is not necessary
Me.FilterOn = False
reading more...
StayerAuthor Commented:
Hi eghtebas.

I just made a new form from scratch and now it works.


Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Train for your Pen Testing Engineer Certification

Enroll today in this bundle of courses to gain experience in the logistics of pen testing, Linux fundamentals, vulnerability assessments, detecting live systems, and more! This series, valued at $3,000, is free for Premium members, Team Accounts, and Qualified Experts.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now