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