The Microsoft Access Database Engine does not recognize...

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
Answer

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);

---
Kind regards, HansV
https://www.eileenslounge.com

55 people found this reply helpful

·

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

 
 

Question Info


Last updated February 4, 2021 Views 19,849 Applies to: