For keys report using nested query - error - engine does not recognize

  • Thread starter Thread starter KB
  • Start date Start date
K

KB

I have a report, which collects its data from a crosstab query, which
in turn collects its data from a standard query.

I run this report from a button on a form, one field on the form
contains the key record to limit the initial query

Criteria: [Forms]![myform_frm]![Record_ID]

The initial query open fine, but nesting seems to cause problems and I
get

The Microsoft Jet database engine does not recognize
"[Forms]![myform_frm]![Record_ID]' as a valid field name or
expression.

I know I've run queries with a key off a form, when I used to program
more actively in Access. Is this something new to 2000. Any fix for
this, or an alternative way around this?

I'd hate to, say, dump the record ID into a scratch table, and key the
query of that.
 
With CrossTab Query, you need to specify the Parameter names and their
types. In your case, I would recommend this for both the CrossTab Query and
the Select Query.

In the Design View of each Query, use the Menu Query / Parameters ... to
access the Parameters Dialog.
 
Back
Top