>So, are you saying that you only want to use a subset of the entire table of names? Based on what criteria? I'm guessing maybe something along the lines of if they type in a name that begins with a "B", then you will only have the "B" names in the dropdown?
>

Yes, that's exactly what I'm trying to do. And yes, the problem with so many records is speed.

Elyse


>I haven't been using VFP long enough to know what the combo's limitations are in terms of number of records, so I don't know what kind of problems you are encountering from that aspect (too slow?)
>
>Bonnie
>
>>I did "tweak" the FPA samples and used them successfully in other areas, but in this case I am dealing with a lot of data. If I create a cursor up front, it can have several hundred thousand records in it, too much for the combo to handle gracefully. And building this cursor would take too long.
>>
>>Elyse
>>
>>>Hi Elyse,
>>>
>>>I would go ahead and use the QuickFill sample from the FPA article, but create a cursor in your form load combining the names and addresses and then use that cursor as your RowSource.
>>>
>>>BTW, you may need to tweak that FPA sample just a bit ... I found a few minor problems with it. I understand there is a class to download here from the UT also, but I haven't had the change to look at it yet.
>>>
>>>Bonnie
>>>
>>>>My instructions are to create a Quicken-style dropdown containing a list of names and address. The user should be able to type in a name and the combo should fill with the list of names with their addresses. The problem is that names and addresses are in 2 separate files, so I can't use the sample that was published in FPA a few months ago. I've tried requerying a view or populating a cursor on the fly as the user types in characters but it takes too long. One possiblity is to fill the combo only when the user tries to drop it down. But whenever I try to populate a combo in the DropDown Event, strange things happen. Either the list shows up in a different part of the form or the list is only partially filled and has up and down arrows where the data should be. Does anyone know how I can populate the combo only when dropped down or is there a better way to handle this altogether?
>>>>
>>>>Thanks,
>>>>Elyse