Crosstab Query Criteria

  • Thread starter Thread starter Shawn
  • Start date Start date
S

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?
 
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
 
Back
Top