Hi specialists,
I want to open a repport with 2 conditions.
part of the code :
Only with the "NN" condition, no problem.
[Datum TA] is a combobox to filter my form based on the date in that combobox.
When I want to open my report access gives me a error 13: Types don't match.
My form is based on a Query and the combox values are from the same Query.
Filtering in my form with that combobox is no problem.
He gives a error when I want to use that combobox value as condition.
What am I doeing wrong?:banghead:
Thanks
Greetz
Pascal
I want to open a repport with 2 conditions.
part of the code :
Code:
DoCmd.OpenReport "Alle Dossiers", acViewPreview, , "[NN] =" & NN And "[Datum TA] =#" & [Datum TA] & "#"
Only with the "NN" condition, no problem.
[Datum TA] is a combobox to filter my form based on the date in that combobox.
When I want to open my report access gives me a error 13: Types don't match.
My form is based on a Query and the combox values are from the same Query.
Filtering in my form with that combobox is no problem.
He gives a error when I want to use that combobox value as condition.
What am I doeing wrong?:banghead:
Thanks
Greetz
Pascal