D
DanWH
Hi,
I'm using a simple select query (Qry_A) to query data from a crosstab query
(Qry_B) and it works fine when I input the criteria of '0' directly in the
field of Qry_A.
However when I input the name of a combo box (or text box, I've tried both)
both on the subform that is based on Qry_A and the master form, I get the
error "...does not recognize [Forms]![formA]![Fieldname] as a valid field
name or expression." I've also tried just using [Fieldname] in the criteria
but get the same error that it is not a valid field name or expression.
I have other queries with this syntax that works perfectly, but for some
reason this query is not working.
BTW, this is an Access 2007 database.
Please let me know what I need to do.
thanks
Dan
I'm using a simple select query (Qry_A) to query data from a crosstab query
(Qry_B) and it works fine when I input the criteria of '0' directly in the
field of Qry_A.
However when I input the name of a combo box (or text box, I've tried both)
both on the subform that is based on Qry_A and the master form, I get the
error "...does not recognize [Forms]![formA]![Fieldname] as a valid field
name or expression." I've also tried just using [Fieldname] in the criteria
but get the same error that it is not a valid field name or expression.
I have other queries with this syntax that works perfectly, but for some
reason this query is not working.
BTW, this is an Access 2007 database.
Please let me know what I need to do.
thanks
Dan