You will resolve your performance problem by using another control for the task. A combobox should not have more than 100 items, IMHO.

---

>I presently have a form that maintains informtion about homes. I use a button to do a "fast" find of a home. That button calls a small form with a combobox on it to list the homes by last name + first name. I found that when I populated the home file with a few hundred homes the "fast" part of find went away. The find form takes several seconds to load the combobox before it appears. I seem to be suffering from a lack of imagination here and would like some suggestions to improve performance.
>
>I tried setting the combo box's RowSource to Home.Last_First with Home.Order set to Last_First in the dataenvironment.
>
>Then I tried an SQL along the lines of:
>SELECT ALLTRIM(Home.Last) + ", " + ALLTRIM(Home.First) AS LastFirst ...
>in the form.init
>
>Both failed to improve performance