hi

i have a textbox which the user enters a criteria. i want it to filter through a datagrid on my form.

e.g. search is 'harry', all records with harry in the first name field should show in the datagrid.

thanks

I am assuming your data grid is a subform? You need something like below

me.[subformName].Form.Filter=[FirtsName]='" & me.[textboxCriteriaControl] & "'"

me.[subformName].form.FilterOn=true