Try using a grid instead. You can download ingrid File#9172 to add incremental searching.
>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
>
>
>Thanks in advance
>Terry
Roi
'MCP' Visual FoxPro
In Rome, there was a poem.
About a dog, who found two bone.
He lick the one, he lick the other.
He went pyscho, he drop dead!