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