Crosstab Query Criteria

[Shawn]

I am trying to create a crosstab query that only displys
data that is chossen by fields with a form. The query
generates an error message as follows: The Micrsoft Jet
Database doesn't recognize ...[Forms]![Form_Search]!
[Construction Item] as a valid field name or expression.

Why is this so?

 

[Jen]

Hi Shawn,

Sorry for the obvious question but...are you sure that
this form and control exists? If so, then are you closing
the search form too early? I would think Access is
throwing this error because the form is closed and Access
can't read it.

Solution: You should close the form after you run your
query. if need be, set the form's visibility property to
false, run the query, then close the form.

Regards,
Jen