Applying a filter in a form

[2410Davie]

Hi everyone

I have a search box on a form that looks for a value you type into that field using a macro 'Apply Filter' [Key Tag Number]="" & [Forms]![RFID Search1]![txtSearch2] & ""

This works great but i also want to clear the field of the text typed in ready for the next search, how would i do this in my macro? or how would i write the same filter in VBA?

Thanks

Davie

[orange]

You may get some ideas and insight from this Search article by Allen Browne.