Home
Search
 
What's New
Index
Books
Links
Q & A
Newsletter
Banners
 
Feedback
Tip Jar
 
C# Helper...
 
XML RSS Feed
Follow VBHelper on Twitter
 
 
 
MSDN Visual Basic Community
 
 
 
 
 
 
TitleLet the user search a recordset using a ComboBox
DescriptionThis 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.
KeywordsComboBox, database, ADO, Recordset, search
CategoriesDatabase
 
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 & "'"
 
 
Copyright © 1997-2010 Rocky Mountain Computer Consulting, Inc.   All rights reserved.
  Updated