MS Access: Invalid reference in expression in Web Form
I encountered the following error while trying to filter something on a Access Web App on SharePoint.
“Invalid reference ‘FieldName’ in expression. You may have attempted to use an undeclared parameter or a field that is not bound to a control on the form or report.”
Here is the Microsoft Version of what to do http://support.microsoft.com/kb/2133239
In English it means that the Web Form can only filter what it can read. So if a column is not returned to the browser it cannot filter it.
So all you have to do is drag the field into the form and make sure it is set it “Visible = No”
Sorry if you were looking for a long-winded explanation with images and Youtube clips.