Using MS Access 2010, I published a small MS Access database to my Enterprise SharePoint site. I'm using a macro to filter results of table based on the value of a combo box. The macro works in Access but not in SharePoint. I receive a message stating "Query error-Failed to filter result". Details below
Macro Name = Macro1
Action Name = Set Filter
'=SQL.LIKE(OpsNo, CONCATENATE.DB(\"*\", ' + Access.Actions.GetFormItemValue('Forms!Navigation Form!NavigationSubform.Form!Combo28',true) + '))'
Error Number = 2950
I added my site as a Trusted Site in database security setting. I opened a module and checked the References. None are missing.
Any help would be greatly appreciated!