filtering subform using textbox
Posted on 2008-11-04
I have a main/subform in an Access 2007 db and am using
Forms![MainForm]![SubForm].Form.FilterOn = False
Forms![MainForm]![SubForm].Form.Filter = "[FieldtoFilter] = '" & Me.[txtFilterRecords].Text & "'"
Forms![MainForm]![SubForm].Form.FilterOn = True
to filter the subform via the textbox onChange event. However, this only displays a record if there is an exact match, e.g. to display the record with "Hello World" in the FieldtoFilter I have to enter the whole "Hello World", I can't just put in "Hello" and have the filter display the matching record(s) (where matching would mean that the field either contains "Hello" (best solution) or begins with "Hello"). I prefer to do this via a filter rather than a new query.