Data1.Recordset.Filter ????????

[Edneeis]

Lets say you have recordset with a FirstName field in the query and you want to limit it to just the first names that start with 'f' then

Data1.recordset.filter="FirstName Like f*"

Lets take the same example and say you want to also take only those with the LastName starting with 'Ma'

Data1.recordset.filter="FirstName Like f* And LastName Like Ma*"

Or if you want to filter by what a user has typed in a textbox

Data1.recordset.filter="Firstname='" & Text1.text & "'"

And to reset the filter back to none

Data1.recordset.filter=""

Sorry about the delay but better late then never