Results 1 to 3 of 3
  1. #1
    Eranka is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Dec 2017
    Posts
    150

    Access Error

    Hi Everyone
    Click image for larger version. 

Name:	5689.jpg 
Views:	14 
Size:	50.6 KB 
ID:	40032


    Please see the attached image, when i open a form the attached error message appear i am unable to find a reson, hope you all could help me out on this

  2. #2
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,941
    check the form filter property on the data tab

  3. #3
    isladogs's Avatar
    isladogs is offline Access MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    6,205
    That message refers to the 'temp query' used for the row source of a combo or listbox on a form.
    As it indicates, the row source has been deleted so code dependant on that triggers the error.
    Open the Search form in design view, find the control (List5) and do one of the following
    1. Restore the missing row source
    2. Delete the control or replace it
    3. Remove the code in form load that depends on that.

    If none of those apply or work, your form may be corrupted
    Colin Riddington, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I know I don't know, I keep quiet!

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

Similar Threads

  1. Replies: 0
    Last Post: 10-10-2018, 12:28 PM
  2. Replies: 1
    Last Post: 07-26-2016, 06:34 AM
  3. Replies: 3
    Last Post: 05-12-2016, 07:06 PM
  4. Replies: 6
    Last Post: 03-17-2016, 02:10 PM
  5. Replies: 6
    Last Post: 09-28-2011, 09:20 PM

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