Crosstab Criteria

[Bret]

Please,
I have a crosstab query that is erroring out when the
criteria for one field is linked to a field in a form.
When its executed I get this error message:
"The Microsoft Jet database engine does not recognize
'[Forms]![C_View]![Store_Name]' as a valid field name or
expression".

However if I enter in a persons name, then all is fine.
I've made sure the form field does have data so thats not
the problem. I have numerous queries with this kind of
form field reference which execute w/ no problem. Is this
a limitation for a crosstab query?

thank you.

 

[[MVP] S.Clark]

How and/or when are you entering the person's name vs. when the error is
occuring. re-explain these steps as I'm confused.


--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

 

[Gary Walter]

Hi Bret,

One guess is that you just need to define the type of
the parameter (unlike some other queries, crosstabs
require this).

In QBE, under top menu item "Query,"
Click on "Parameters..."

In 2-column dialog box,

Parameters
[Forms]![C_View]![Store_Name]

Data Type
Text