Clear a filter and Show all data on continuous form via a command button is not working properly

wire_jp · Post by **wire_jp** » 23 Nov 2023, 12:43

Hello,

I have a form called "frmAnyOtherVolAreasSearchByName" and there is a "Show All" command button to clear the filter and show all data on the continuous form. The data is not clearing the filter to show all of the data.

Similar issue with the form called "frmAnyOtherIdeasSearchByName".

The One Drive link with the MS database is attached: =

https://1drv.ms/f/s!AtOdPG-IN8CYgcV-YYl ... Q?e=Sbf4vE

Kind regards,

wirejp

Gasman · Post by **Gasman** » 23 Nov 2023, 13:21

I generally set the filter to "" AND switch the filter off.

Post by **HansV** » 23 Nov 2023, 14:35

As Gasman wrote, this should be sufficient:

Code: Select all

Private Sub CmdAnyOtherVolAreasNameShowAll_Click()
    Me.Filter = ""
    Me.FilterOn = False
End Sub

wire_jp · Post by **wire_jp** » 24 Nov 2023, 14:08

ok, Gasman and Hans: thank you for your kind help. As always, I appreciate your help.

Eileen's Lounge

Clear a filter and Show all data on continuous form via a command button is not working properly

Clear a filter and Show all data on continuous form via a command button is not working properly

Re: Clear a filter and Show all data on conftinuous form via a command button is not working properly

Re: Clear a filter and Show all data on conftinuous form via a command button is not working properly

Re: Clear a filter and Show all data on conftinuous form via a command button is not working properly