hi guys - pulling my hair out with this one...
code:-----------------------------------------------------------------------
-------
Dim oRs As ADODB.Recordset
Dim strSQLString As String
strSQLString = "SELECT"
strSQLString = strSQLString & " customer.*,"
strSQLString = strSQLString & " Hardware.hardwaretype,"
strSQLString = strSQLString & " Hardware.hardwaredesc,"
strSQLString = strSQLString & " Hardware.hardwareprice,"
strSQLString = strSQLString & " Invoiced.TransactionDate,"
strSQLString = strSQLString & " Invoiced.TransactionAmount,"
strSQLString = strSQLString & " Invoiced.TransactionNumber"
strSQLString = strSQLString & " FROM"
strSQLString = strSQLString & " Hardware"
strSQLString = strSQLString & " INNER JOIN"
strSQLString = strSQLString & " (customer"
strSQLString = strSQLString & " INNER JOIN"
strSQLString = strSQLString & " Invoiced ON Customer.CustomerID =
Invoiced.CustomerID "
strSQLString = strSQLString & " ON hardware.hardwareidID =
Invoiced.hardwareID)"
strSQLString = strSQLString & " WHERE (Invoiced.TransactionNumber = " &
InvToFind & ")"
----------------------------------------------------------------------------
--
im getting syntax error on the where line..
anyone know where im going wrong?
fenster.