Limit to list - slow second time

[TOPSie]

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??

[Micron]

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)?

[Welshgasman]

Why çan't you step in?