SQL query question [Resolved]

[Kalilian]

I have a db with a table called Customers. There are two columns in Customers: CustomerCode and CustomerName.

My vb form has a combo box with a list of the customer code, a text box, and a button.

What I want to do is: If a user chooses a customer code from the combo box I want the customer name to show in the text box.

This is the SQL query that I have been using:

strSQL = "SELECT CustomerName FROM Customers WHERE CustomerCode = '" & cboCustomerCode.Text & "'"

The problem i'm having is that the result of the customer name will not show on the text box.

This is what I used to put the result in the text box:

txtCustomerName = strSQL

Is this correct?