I used the Builder to make a listbox with specific fields from my table. RowSource are various field names from my table and RowSourceType is Fields.

When I run my Main form I press the Find button which takes me to my Search form which contains the listbox described above. Since my table is already opened I get an almost instantaneous display of my fields from my table. Several thousand records in total.

My question is -
I have a combobox that will allow a user to pick a field name to search on that is one of the field names in my listbox. Also I have textbox that will be used to enter a partial number of characters to search on as defined by the user's choice in the combobox using the fields in the listbox and redisplay the fields that match my incremental search in the listbox and dropping the ones that don't match from the listbox. What is the best way to do this so that my listbox loads as quick as when I intially come to my Search form?

I have SCAN ENDSCAN right now, but I would like to make the listbox redisplay faster after searching using the RowSource fieldnames, RowSourceType Fields for speed and efficiency. Right now I have to SCAN through the whole table sequentially to repopulate the listbox after searching. I could probably use LOCATE, but isn't there a better way using Fields that are already there? Since the whole table has already been loaded once in the beginning. Your thoughts would be helpful. Thanks very much.