Might be very simple to everyone. But I need it soon. No time to research.

VB Code:
  1. Dim ADOConOle As OleDb.OleDbConnection
  2.     ADOConOle = New OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source=" & Application.StartupPath & "\Accounts.mdb")
  3.     Dim rsLocal As New OleDb.OleDbDataAdapter
  4.     Dim rsCurrent As New DataSet
  5.     rsLocal.SelectCommand = New OleDb.OleDbCommand("SELECT * FROM CUSTOMER", ADOConOle)
  6.  
  7.     txtCustID.DataBindings.Add("text", rsCurrent.Tables(0), "Cust_Id")
  8.     txtName.DataBindings.Add("text", rsCurrent.Tables(0), "Name")
  9.     txtAddress1.DataBindings.Add("text", rsCurrent.Tables(0), "Address1")
  10.     txtAddress2.DataBindings.Add("text", rsCurrent.Tables(0), "Address2")
  11.     txtAddress3.DataBindings.Add("text", rsCurrent.Tables(0), "Address3")
I just want to do display a record (like Find method in ADO) for the entered ID in txtCustID field.

Thanks

Susindran