Sql Help on recordset multiple table access

I am having problems with getting an MSFlexigrid to show data from multiple tables at once.

i am sure that the sql is to blame

i need to reference firstname and lastname from a different table if the customer number matches with the account number

SELECT ACNumber, OpenBalance, TransType, TransAmt, ClosingBalance, Date, FirstName, LastName From LoanAcHistory, Customer WHERE ((LoanAcHistory.CustomerNumber = LoanAccount.CustomerNumber) AND ('" & iAccSearch & "' = LoanAccount.ACNumber))
ORDER BY Customer.LastName"

You are missing the LoanAccount Table from your FROM clause. Also remove the " from your ORDER BY. Try that, let me know if you are still having problems.