Run-time error 2001 when I build a filter

  • Thread starter modmans2ndcoming
  • Start date
M

modmans2ndcoming

I am building a filter from a set of fields for my users to search the
database. I have the whole "if not isnull(textfeild) then" stuff....
and when I stick to fields that relate to text it works fine... I have
an auto number fiend (relates to the item ID) and a date field. How do
I extract these pieces of information and add them to the filter
string in order for searches to be done on them?

Thanks

Jeremy
 
Top