I am trying to set strCustomerNumber to CustomerNumber from tblcustomers
The tricky part is It has to be a specific Customer, so I have to retrieve the customerName from ddlCustomers before I can get the correct number here is my code:
Dim strCustomerNumber as new string("") strCustomerNumber = ("SELECT CustomerNumber from tblcustomers Where CustomerName = " [U]ddlCustomers[/U])
I am getting ')' expected on "ddlCustomers"
Anyone have any suggestions?