top of page

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.

Adrian

2 views0 comments

Recent Posts

See All
bottom of page