G
Guest
I have a form that the user needs to have filtered on certain criteria.
I can set the filter for the 'ident' field, but when I try adding the date
filter I get a 'type mismatch' error. I've tried different ways of applying
the filter, without success, and now I am asking if somebody could give me a
nudge in the right direction.
The code I have is:
Me.Filter = "ident = 'AP' OR 'SI'" And "invoice_date >= show_start_date"
And "invoice_date <= show_end_date"
The show_start_date and show_end_date fields are unbound.
Thanks
I can set the filter for the 'ident' field, but when I try adding the date
filter I get a 'type mismatch' error. I've tried different ways of applying
the filter, without success, and now I am asking if somebody could give me a
nudge in the right direction.
The code I have is:
Me.Filter = "ident = 'AP' OR 'SI'" And "invoice_date >= show_start_date"
And "invoice_date <= show_end_date"
The show_start_date and show_end_date fields are unbound.
Thanks