MS Access Crosstab Parameters from a Form Combo box.

[mgrady11]

I am trying to set up a crosstab query parameter to use a criteria from a combo box on a form.

The Parameter is [Form]![Marketing Billing]![PMT MO ID] and Data type Short Text.

However, when I run the query, it pops up as a "Enter Parameter Value" box.

Can you direct me to some useful links?

 

[ranman256]

every query can ignore form parameters EXCEPT crosstab queries.
for Xtabs , you MUST enter the param in the PARAMETERS section:
in query design,click PARAMETERS button on the toolbar,
in the 1st slot, paste your param: [Form]![Marketing Billing]![PMT MO ID], as text
save.

now the Xtab query will run.

 

[mgrady11]

every query can ignore form parameters EXCEPT crosstab queries.
for Xtabs , you MUST enter the param in the PARAMETERS section:
in query design,click PARAMETERS button on the toolbar,
in the 1st slot, paste your param: [Form]![Marketing Billing]![PMT MO ID], as text
save.

now the Xtab query will run.

That is currently how it is set up, however, when running the query, a pop-up box still pops up.

 

[ranman256]

formS
[Forms]![Marketing Billing]![PMT MO ID],