Cross Tab Query Criteria

  • Thread starter Thread starter Robert W
  • Start date Start date
R

Robert W

I am attempting to pass the data in the following field to
a column heading criteria


[Forms]![frmFacilitiesByVendorBySelectedWells]![Text43]


I get an error message that say the Microsoft Jet Engine
does not recognize [Forms]!
[frmFacilitiesByVendorBySelectedWells]![Text43]as a valid
field name or expression

Have even tried the Eval([Forms]!
[frmFacilitiesByVendorBySelectedWells]![Text43]) function
and that too errors out.

Any thoughts would be greatly appreciated.

Robert W.
 
You must specify the query parameters in crosstabs. Select Query|Parameters
and enter
[Forms]![frmFacilitiesByVendorBySelectedWells]![Text43] Text (or
whatever)

BTW: do youself (and others) a favor by giving Text43 a meaningful name.
 
Back
Top