Filter with Toggle

[Edwik]

Hi !

I have in Form textBox and toggle button.

How could i Filter Form by Value in TextBox? (when toggle button is pressed, Form show records filtered by texbox, when unpressed - shows all records.)

Thank You in advance!

 

[ScottGem]

Hi !

I have in Form textBox and toggle button.

How could i Filter Form by Value in TextBox? (when toggle button is pressed, Form show records filtered by texbox, when unpressed - shows all records.)

Thank You in advance!

me.Filter = Me!textbox

or

Me.Filter = ""

 

[Edwik]

Thank You, it works:

me.Filter = Me!textbox
me.FilterOn = True