Parameter query will not work.

[Frank Martin]

I have a crosstab query and I need a chart based on this.

I have formatted the chart and when I select the data in the criteria
section of the query ("electricity" Or Is Null) the chart works OK.

But when I use the Expression Builder to select a LedgerAccountName
(Forms!FrmLedgerCHART!Combo1) I keep getting the following error message:

***

The Microsoft Jet database engine does not recognize <name> as a valid field
name or expression. (Error 3070)

The specified name is not a recognized field name or a valid expression. In
a query, this error can occur if you enter a name that improperly refers to
a database, table, or field.



Possible causes with Microsoft® Access:



You have a parameter in a crosstab query or in a query that a crosstab query
or chart is based on, and the parameter data type is not explicitly
specified in the Query Parameters dialog box. To solve the problem:

In the query that contains the parameter, specify the parameter and its data
type in the Query Parameters dialog box. And;

***

I tried this but to no avail, and this error message keeps occuring.

The "LedgerAccountName" is a text field.

I have never had this trouble before, and I have many similar charts in my
business database, all of which work well.

Please help, Frank

 

[Frank Martin]

Sorry, false alarm.

I had to put "Forms!FrmLedgerCHART!Combo1" into the Parameter field, and not
"LedgerAccountName".