MS Access Crosstab Parameters from a Form Combo box.

mgrady11

New Member
Joined
Apr 18, 2017
Messages
11
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?
 

Some videos you may like

Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"

ranman256

Well-known Member
Joined
Jun 17, 2014
Messages
1,842
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

New Member
Joined
Apr 18, 2017
Messages
11
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.
 

Forum statistics

Threads
1,089,644
Messages
5,409,497
Members
403,266
Latest member
HMR120

This Week's Hot Topics

Top