Qry Criteria has problems in my crosstab qry.

[gpierce9]

1 - Idea1: I am doing a crosstab qry. The following works in all my other type of qry but not this crosstab.
I have below in the 1st Qry that collects the data. It works fine and collects the proper REPID.

[forms]![frm8100Finance]![cboRepID]

In the 2nd Qry, the crosstab, I include the REPID as a row heading.
It bombs out saying:
MS database engine does not recognize '[forms]![frm8100Finance]![cboRepID]' as a valid field name or expression.

2 - Idea2: So I went back to Qry1 and instead tried using a criteria of [enter RepID].
But the Qry2 crosstab still barked the same bad answer.

3 - Idea3: Instead, I hardcoded 36 onto the Qry1 RepID criteria row.
The Qry2 crosstab works fine. It accepted the hardcoded 36.



4 - How could I get the idea#1 to work using the [forms]![frm8100Finance]![cboRepID] ??
Maybe I need a formatting deal so that Qry2 recognizes it as a number answer?

thank you. Glen

[June7]

Perhaps use PARAMETERS - review http://allenbrowne.com/ser-67.html#Param