Results 1 to 3 of 3
  1. #1
    TOPSie is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Mar 2021
    Posts
    153

    Limit to list - slow second time

    I have just discovered that an application I inherited uses a combo box with "limit to list". So if you start typing it homes in on an entry from the associated record in the row source (query).



    All is good. But if you don't close the surrounding form and reenter a value in the combo box it takes up to 10 seconds to respond with a value.

    The "code" which does this is hidden away in the guts of Access, so I can't "step in" to the code and see what is happening.

    Anyone know anything about this??

  2. #2
    Micron is offline Very Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    13,421
    IIRC, limit to list does not do what you describe (filter as you type). That can occur if you have Auto Expand set to yes. It is also often done with code. You seem to be saying that the code is not viewable, so is the db an .accde file? If so, the original version that the accde is based on should be able to provide it. If it's accdb or mdb then the code should be viewable. So if your combo filters via code, I don't see how we can help much if we can't see it. If you are able to post a db copy, see How to Attach Files at the top of this page.

    EDIT - since you didn't mention it, I presume that performance of other applications is OK (like Excel)?
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  3. #3
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    6,550
    Why çan't you step in?
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

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

Similar Threads

  1. Slow Sharepoint List opening 1st time with access
    By SteveApa in forum SharePoint
    Replies: 2
    Last Post: 04-17-2018, 09:51 AM
  2. Combo box limit to list doesnt limit
    By mcmcd99 in forum Access
    Replies: 6
    Last Post: 11-09-2017, 07:31 PM
  3. Replies: 3
    Last Post: 10-09-2017, 06:43 PM
  4. Replies: 5
    Last Post: 06-17-2014, 06:30 PM
  5. Replies: 9
    Last Post: 05-27-2014, 04:53 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