Crosstab Query doesn't accept parameters?

[ahmun]

Hello everybody.

I got a problem and a limited time!

I'm trying to use a parameter query (whose source is a crosstab query) to custom-filter data on a table based on the user's selection of a Pull-down list.

But... I get the error message "The Microsoft Jet database engine does not recognize '[forms]![MainSwitchboard]![dtmCurrentMonthEnd]' as a valid field name or expression."

Can anybody help me get around this problem? Should I save all the values of the crosstab query in a temporary table to avoid this error message (I've used parameter queries on tables with no problem) or is there a simple trick?

See thread702-490127 for the details and my table structure.

Earnie Eng
If you are born once, you will die twice.
If you are born twice, you will die once

 

[3587]

Open your query in design view, select Query | Parameters and enter your parameters again in the Query Parameter dialog.

Good Luck,

 

[ahmun]

THANK YOU! It worked...

something so simple!... Earnie Eng
If you are born once, you will die twice.
If you are born twice, you will die once