Forms and Crosstab queries 1

[Timko]

I am trying to open a report based on a crosstab query, with certain parameters that change depending on what the user has chosen from a form. But I can't get it to work.

Basically the user chooses a report from a combo box(parameter 1) then another form allows them to choose 2 more parameters (date and country) again from combo boxes

I have tried leaving the second form open with all 3 parameters on it, then opening the form, but it just brings up the error

"The Microsoft Jet database engine does not recognize <name> as a valid field name or expression"

I have been through all the microsoft help and followed what it suggests, but it doesnt work.

hope someone can help me

Timko

 

[dhookom]

You must open the crosstab in design view and select Query|Parameters and then enter your criteria expressions and data types. IE:
Forms!frmDates!txtStartDate Date/Time


Duane
MS Access MVP
Find out how to get great answers faq219-2884.