Printable View
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
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.
Do you have an example code which I could see?
smh
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.
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