|
|
|
| Title | Let the user search a recordset using a ComboBox |
|---|
| Description | This example shows how to let the user search a recordset using a ComboBox in Visual Basic 6. When the user selects an item from the ComboBox, the program calls teh Recordset's MoveFirst method, and then its Find method to find the target record. |
|---|
| Keywords | ComboBox, database, ADO, Recordset, search |
|---|
| Categories | Database |
|---|
|
|
|
Thanks to Gamal Ahmed.
When the user selects an item from the ComboBox, the program calls its Recordset's MoveFirst method. It then calls the Find method to find the selected record.
|
|
rs.MoveFirst
rs.Find "Name='" & Form1.Combo1.Text & "'"
|
| |
|
| |
|
|
