remove filtering of a form

[maxbre]

Hi all



I have attached the following vba code to a button in a form in order to filter data to be visualised

>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>>>
Dim filtro_struttura As String

filtro_struttura = "SELECT * FROM registro_ssa WHERE registro_ssa.cod_struttura=[Forms]![ms_data_entry]![cod_struttura]"

Me.RecordSource = filtro_struttura

Me.Requery

>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>>>

Now I’m stuck because I want to create another button to remove the filtering and display all data
Any help for this?

Thanks

[RuralGuy]

Why not apply and remove a filter instead of the RecordSource?

[maxbre]

thanks for your reply

the reason is why I need to create a button on the form to perform the operation of filtering (for the sake of conciseness I do not expalain much more here)

anyway, to "go back" I have this possibility

>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

Dim filtro_struttura As String

filtro_struttura = "SELECT * FROM registro_ssa "

Me.RecordSource = filtro_struttura

Me.Requery
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

but the aftermath is that I'm selecting again all the recordsource
And by considering the possibility of having many more filtering buttons is not much a convinient solution: so therefore I need to find a way to deselect just that specific filtering and not all

thsnks

[RuralGuy]

I'm not sure you can avoid creating a dynamic WHERE clause every time you want to change the filtering.