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

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