hi ive been trying to insert specific data into a certain textbox from an access table, ive managed to pull the information from one field onto a listbox but i cant grab specific data and load it onto a textbox: here is the code, if anyone can help please that would be great...

    Dim cnString As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\student.mdb;User Id=admin;Password=;"
    Dim dataBaseConnection As New OleDbConnection(cnString)
    Dim dataBaseCommand As New OleDbCommand("SELECT Name FROM Student WHERE Student Number = """ & txtSearch.Text & """", dataBaseConnection)
    Dim dataReader As OleDbDataReader
        dataReader = dataBaseCommand.ExecuteReader()

        'Manual Binding - ultimate control
        Dim i As Integer

        For i = 0 To dataSet.Tables(0).Rows.Count - 1
    Catch ex As Exception
    End Try

Please read this article on how to connect to an access DB and fetch results. I will be posting more articles with samples soon. Click here