I have a form with several text boxes that are populated through code from a database. This form is accessing a customer table that I have set up on the database. What I want to be able to do, is have the text box autocomplete the customer's name as you type it. Meaning that it would have to sort the names in the database and be able to run through them as you type. Aaron Young gave me some code that would do something similar with a text box and a list box. I suppose I could do the same thing, but I think that would slow it way down, if I took the time to first read every customer off the table and then populate a listbox. Is there any other way to do it? I have the names broken down into:

  • Company Name
  • Last Name
  • First Name
  • Middle Initial


All four of these are separate columns in the table, and I need to be able to search them all. Thank you so much for your help.

------------------
Ryan


[This message has been edited by Gimpster (edited 01-21-2000).]