textbox help

S

Smithbr

Member
Joined
Jun 3, 2003
Messages
15
I am creating an app that will allow the user to type in the invoice number and it will retrieve all relevant data associated witht the invoice number. Now the invoice info is from an accountng program that is linked to access. I can not change the properties of hte access table because it is linked. The problem is that the invoice number in access it set up as a text field. I want it so the user does not have to type quotes around the invoice number when they use the app. The code I tried before is:
Dim strsql As String = "SELECT InvoiceNumber, Division, CustomerNumber, SalespersonCode, NonTaxableAmount FROM AR4_OpenInvoice WHERE InvoiceNumber = " & txtinvnum.Text & " "

This woudl not work for some reason...I thought that this was the right way. Any suggestions would be great. Thanks
 
try this:

Code: 
Dim strsql As String = "SELECT InvoiceNumber, Division, CustomerNumber, SalespersonCode, NonTaxableAmount FROM AR4_OpenInvoice WHERE InvoiceNumber = " & txtinvnum.Text & ""
 
Back
Top