Ok so first off I am completely new to VB.net. I do however have a slight background with VBA particularly with MS Access, so I am not completely lost. I am recreating my Access database application in VB.net This is my first post here, and I am sure there will be many more to come, but lets get to my particular question... (Oh yeah, BTW I am using Visual Basic 2008 Express Edition)

I created a new project and added an Access database through the wizard, which automatically created a dataset for the database. On one of my forms I have, esentially, a search form. What I want to happen is have a text box, and as I start typing display a search result from my customers table in the list box under it. So for example, I type "A" and all customer names that start with "A" are displayed in the list box. I continue typing with a "p" (full string is now "Ap"), then all customer names that start with "Ap" are displayed and so on...

I did search on my own first before posting this and found a few tips but cant really get it to work the way I want. This is what I have... I know I would put this code in the keypress event of my test box, but just until I get it working I attached it to a button to search. (I basically got this online and not even sure its the correct usage.
Code:
Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click

        'Create a dataview
        Dim dv As New DataView

        'Associate the dataview to dataset(Dataset table)
        dv.Table = RGB_Tools_back_endDataSet.Tables("Customers")

        Dim drv As DataRowView 'Data Row View object to query DataView object

        'Filter based on a text box value selected
        dv.RowFilter = "[Last Name] = " & textBox1.text
        'Retrieve my values returned in the result
        For Each drv In dv
            ListBox1.Items.Add(drv("Last Name"))
        Next
The item in red is where i get an error. it sucessfully builds and i open the find form enter a last name that I know is in the customers table, but I get the error "Cannot find Column ["whatever name i typed inthe text box"]

So first of all is this the correct way of going about what I want to achieve? If so how can I get it to work? If not what other ways can someone suggest for me. BTW the next step for the user would be to double click the customer in the list box they are searching for to open the customer Details form for that customer, so I would need an ID or Index attached to that item to be able to open that record in another form.