If the code I gave you is generating that huge string something is wrong. A field should only be in that filter string if the value of the field is NOT null (non zero length) which tells me your statement is not evaluating correctly. NOTE your the 'new' form I gave you has field names that exactly match the fields in your table, the string you are posting does not, for instance your field name is 'custname' where on your table it is [customer name]. For the code I gave you to work the fields on the form have to be named exactly as they appear on the table.
Secondly, the search fields have a D for date, T for text or N for number in the TAG property, the search string is built based on what you have in the TAG property, in your case I have 'date added' with a tag of D (date), company zip and owner/principal zip and balance with a tag of N (number) and everything else with a TAG property of T (text) the code then figures out the appropriate syntax for the filter string. (See the select case statement)
To clear your search items
Code:
dim ctl
if len(ctl.tag) >0 then
ctl = null
endif
for each ctl in me.controls
next ctl
this is making use of the fact that you have your 'search' fields with TAG property that is non zero length to clear them out.