Share via

Disable the filter/unfilter button on forms

Anonymous
2018-03-23T12:02:14+00:00

Hello,

Is there any way or method to disable the filter/unfilter button on the bottom of a form near the navigation buttons?

When users click this button after filtering the records, it displays all the existing records associated with the form which I do no want.

Is there a way to disable this feature, to avoid displaying all the records to users?

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Anonymous
2018-03-23T12:36:03+00:00

ciao Faraday,

try this on apply filter event :

Private Sub Form_ApplyFilter(Cancel As Integer, ApplyType As Integer)

Cancel = ApplyType = 0

End Sub

HTH.

Sandro.

Was this answer helpful?

6 people found this answer helpful.
0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2018-04-03T13:01:35+00:00

    Thanks a lot,

    I have tried it as suggested and it's working.

    many kudos

    Was this answer helpful?

    0 comments