How would you do this...

[smh]

I have had a request for my program to do an auto-search throught the database while they are typing in a number in a textbox to pull up the corresponding record. I am using Access 97 as my database. Does anyone have an example code for this or a site where I could view some?

smh

[jp_schwartz]

In that case I use the change event. Fill a recordset and display it when the user types something. One comment: If the table you´re using is too large, this could be very slow, so you have to evaluate the impact on your performance.

[smh]

Do you have an example code which I could see?

smh

[HeSaidJoe]

Textbox...I don't know about that one.

I use a dbComboBox, style2, matchededit = true.
As you type in the dbCombo/Textbox the corresponding item is moved to the top of the list. Click on the item and the record can be shown either by code or dbTextboxes.

[smh]

I'm having a few small problems.

1. I don't have a matchededit property listed. I am using version 6.0 so maybe there's differneces in our versions. I do have a matchedentry property, so I will assume that is the same.

2. In my program, when the form pulls up, it is already displaying a record from the database. I want the user to have the option to scroll through the records, or type in the record number and go directly to a specific record. Therefore, I think I need to use option 0 - dbcDropdownCombo.

3. I have the combo box filled with information, but I am unsure how to code it so that it changes the record to display the record which I am searching for. I tryed using an SQL statement to pull the record matching the contents of the dbComboBox, but I don't know where to go from there.

Sorry for taking up so much time. Thanks

smh