Crosstab Query Error

[Ray67]

Hello



I have a form where user would enter date and the report would open. When i click ok on the form i get this error
Run-Time error 3070
The Microsoft jet database engine does not recognize [Forms]![F_TransactionsDadReportForm]![servicefrom] as a valid field name or expression.

This is what i have in my query Criteria Between [Forms]![F_TransactionsDadReportForm]![servicefrom] And [Forms]![F_TransactionsDadReportForm]![serviceto].

When i click on Debug it takes me to VB DoCmd.OpenReport "R_TransactionsDadReport", acViewPreview. I don't see anything wrong with DoCmd .

What i'm i doing wrong???


Thank you

[June7]

The query can't find the referenced controls. Are they in a subform?

Show the full sql statement of the query.

Is this issue a duplicate of https://www.accessforums.net/reports...ort-29441.html

Please don't post duplicate threads on same topic.

[Ray67]

Yes it's the same issue.

[June7]

I tested your report from the db posted in other thread. It runs after I fixed the report name as described in that thread. Can't replicate this issue.