I am trying to publish an updated form to my SharePoint site. I had a previous form that is now obsolete and is going to be replaced with this version 2. I have checked the database and it confirms that everything is Web Compatible. However, when I change my "Web display form" in the options to my new form, I get an error message on SharePoint that says "The 'BRC Form' is not available. Click here to try again". I cannot figure out why this form will not load on the page.
I have tried to find out what the problem is but I can't seem to figure it out. The closest thing I have found is an error that keeps popping up in my Application Log. The description says "Invalid reference 'LocalVars.strSearch' in expression. The form associated with this error is 'BRC Form'
Here is just a look at the Macro that uses the LocalVars expression.
Does anyone know what is going on here? I really need help on this one.