Form Filters (1 Viewer)

[paulmcdonnell]

Hi guys,

I want to apply a filter to my form depending on the value of a text box..
Sounds simple but I'm not sure of the code ...Any heros out there know?

Many thanks
Paul

 

[Jon Holmes]

Paul,
Attached to the After Update event of the textbox defining the filter would be the statement;
Me.Filter = "Filter_Field = '" & Me.txt_Filter & "'"
The example above is for a text search.
Attach the line
Me.FilterOn = True
to the Form's Open event.
Jon