I have an access 2010 web form that I've uploaded to SharePoint but the filters (via SetFilter) are giving me an error, refusing to filter. Everything works in Access but the translation to SP is giving me problems.
My form has a combobox dropdown which will make visible any one of six textboxes from which a user can input a search string that executes a filter via a command button which holds the code for the filter.
I’ve attached a snapshot of my code. Through trial and error I've discovered that everything runs if I omit the & “*” at the end of the SetFilter Where condition. But in doing so I lose the flexibility I need for partial search strings returning the appropriate results.
All of my data is text and text boxes formatting is blank.
I've been at this for a very long time and its driving me crazy. Please can anyone help? I've also attached the error message I get in SharePoint and a cleansed shot of my form if it helps.