The Microsoft Access Database Engine does not recognize...

Question

Forms![Inventory Reports]![SupplierName]  as a valid field name or expresion.

This is a combo box on an open form, it has a selection chosen in that combo box, and I put the name of that combobox into the criteria section of the query grid using "build," go to forms, choose form, choose combo box, so I know it is spelled correctly.

Isn't this like the simple stuff that is just supposed to work?

What am I missing?

Answer 1

Ah! It is a crosstab query. You need to declare the parameter explicitly. You can do this in two ways:

1. Open the query in design view.

Click Parameters in the Show/Hide section of the Design tab of the ribbon.

Enter [Forms]![Inventory Reports]![SupplierName] in the Parameter column and Text in the Data Type column, then click OK.

• or -

2. Insert the following line at the top in SQL view (this line must come before the existing SQL string):

PARAMETERS [Forms]![Inventory Reports]![SupplierName] Text (255);

Answer 2

I tried this and it did not resolve my problem.

I tried adding the parameter in both the originating query and the crosstab query but I still get the error message.

Answer 3

Post the SQL where it is used and gives the error.

---

Build a little, test a little.

Answer 4

Does your combo box happen to be on a subform? If so, you'd have to use

Forms!Mainformname!Subformname!SupplierName

Answer 5

Nope.  One form, has about 20 buttons and 8 combo boxes.  The buttons run queries, and many of them use one or more combo boxes the same way, and they work fine...