I have generated some SQL code
SELECT Invoice.InvoiceID, Invoice.CustomerID, Invoice.RouteNumber,
Invoice.TreatmentType, Invoice.Information, Invoice.StreetAddress,
FROM (Invoice INNER JOIN
Customer ON Invoice.CustomerID =
WHERE (Customer.CustomerID = '?')
When i test it in the query generator everything works.
However when i add the following code to my vb form in order to populate the table with the correct data. The query will not work:
The system builds with no known errors however it does error when i try to open the page and takes me to a line of code in my form..
The error is: Conversion from string "" to type 'Integer' is not valid.
I have checked in my database that they are both integers which is
I have looked through the propperties on the text box to ensure they are
correct and i have found no problems?