>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
Thanks
As I thought - a failure of imaginagion.
And as of now I too agree ComboBox = less than 100 items.
Terry
It is impossible to make programs idiot proof. Idiots are too cleaver.
MCP( Tcp/Ip )