Results 1 to 4 of 4
  1. #1
    10 Gauge's Avatar
    10 Gauge is offline Getting the hang of it...
    Windows 7 64bit Access 2007
    Join Date
    Feb 2011
    Location
    Fredericksburg, VA
    Posts
    202

    Angry Error: Record source specificed on this form does not exist.

    I have been fighting with this error for a while now and I must come for help....



    --------
    The exact error message is:

    The record source '~sq_CTrainedEmployees subform~sq_cEmployeeInfoID' specified on this form or report does not exist.

    The name of the recordsource may be misspelled, the recordsource was deleted or renamed, or the recordsource exists in a different database.
    ---------

    I am unsure of where it's pulling this ~sq_cTrainedEmployees subform~sq_cEmployeeInfoID string from. The recordsource for the form is not set as such yet this is the error that I get. EmployeeInfoID is also a valid field on the linked table.

    This happens after adding a combobox to the form. I have quadruple verified that my row source query string is correct....

    I figure I am overlooking something somewhere that's throwing up this message.

    Thanks in advance for your help.

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    I would start by *importing* everything into a fresh new db and see if the problem follows. http://www.btabdevelopment.com/ts/impnew

  3. #3
    10 Gauge's Avatar
    10 Gauge is offline Getting the hang of it...
    Windows 7 64bit Access 2007
    Join Date
    Feb 2011
    Location
    Fredericksburg, VA
    Posts
    202
    Quote Originally Posted by RuralGuy View Post
    I would start by *importing* everything into a fresh new db and see if the problem follows. http://www.btabdevelopment.com/ts/impnew
    That worked, how crazy... What causes this???

    Thanks RG!

  4. #4
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    It points to some sort of corruption in your application. Importing tends to leave corruption behind. It is generally the first thing I try when weird things start happening.

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

Similar Threads

  1. Form Record Source - Best practices.
    By ser01 in forum Forms
    Replies: 1
    Last Post: 06-11-2011, 11:32 AM
  2. Resetting Record Source on Form
    By Cheshire101 in forum Programming
    Replies: 5
    Last Post: 05-05-2011, 08:52 AM
  3. If record does not exist, open add new record form
    By RobertIngles in forum Programming
    Replies: 2
    Last Post: 02-01-2011, 08:47 AM
  4. Replies: 3
    Last Post: 11-22-2009, 07:46 AM
  5. Changing the record source in a form
    By lmichaud in forum Forms
    Replies: 1
    Last Post: 07-09-2006, 09:20 AM

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