Results 1 to 2 of 2
  1. #1
    SethG is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Apr 2014
    Posts
    15

    Error: "Form is not available"

    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.Click image for larger version. 
<br /><script async src=
    Name: BRC Form not available.png  Views: 8  Size: 5.8 KB  ID: 20400" class="thumbnail" style="float:CONFIG" />


    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'

    Click image for larger version. 

Name:	BRC Form is not available.png 
Views:	8 
Size:	13.0 KB 
ID:	20399


    Here is just a look at the Macro that uses the LocalVars expression.

    Click image for larger version. 

Name:	BRC Form is not available2.png 
Views:	8 
Size:	9.5 KB 
ID:	20398

    Does anyone know what is going on here? I really need help on this one.

  2. #2
    rpeare is offline VIP
    Windows XP Access 2003
    Join Date
    Jul 2011
    Posts
    5,442
    is your form name localvars?

    if so why doesn't your where condition say [document] like [forms]![localvars]![strsearch]?

    I am not familiar with web based databases enough to guess here (because I don't use macros, just code) but I would think the object type needs to be specified.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 1
    Last Post: 09-03-2014, 03:27 AM
  2. Suppress "Error" message following "Cancel = True"
    By GraeagleBill in forum Programming
    Replies: 7
    Last Post: 03-23-2014, 05:40 PM
  3. Replies: 1
    Last Post: 03-14-2013, 12:39 PM
  4. Replies: 2
    Last Post: 11-04-2011, 02:45 AM
  5. "Group By" causes "ODBC--Call Failed" error
    By kaledev in forum Queries
    Replies: 1
    Last Post: 03-09-2011, 02:43 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums