The SQL view shows what you typed, but the graphical portrays it as two
seperate fields.

SELECT tblAccts.AccountID, tblAccts.AccountType, tblAccts.BankName,
tblAccts.AccountNumber, tblAccts.BankRoutingNumber,
tblTransactions.AccountID, tblTransactions.TransType,
tblTransactions.CheckNu, tblTransactions.TransDate,
tblTransactions.TransactionID, tblTransactions.DateCleared,
tblTransactions.PayeeID, tblTransactions.TransDesc,
tblTransactions.Withdrawal, tblTransactions.Deposit,
tblTransactions.ClearedOnline, tblTransactions.ClearedOnStatement,
tblTransactions.Taxable, tblTransactions.TransNote,
tblTransactions.TransProb
FROM tblAccts INNER JOIN tblTransactions ON tblAccts.AccountID =
tblTransactions.AccountID
WHERE (((tblAccts.AccountID)=[Forms]![frmLedgers]![lsbAccounts])) OR
((([Forms]![frmLedgers]![lsbAccounts]) Is Null))
ORDER BY tblTransactions.TransDate, tblTransactions.TransactionID;


Form Name: frmLedgers

Row Source:
SELECT [qryAcctBalances].[AccountID], [qryAcctBalances].[AccountName],
[qryAcctBalances].[BankName], [qryAcctBalances].[AccountNumber] FROM
[qryAcctBalances] ORDER BY [AccountID];

Bound Column: 1




That implies that there is no record that matches the combo box. If you
think that is not correct, please post the SQL view of the query, the
actual name of the form, and the following properties of the combo box:

Name
Row Source
Bound Column


--
Dirk Goldgar, MS Access MVP
Access tips: www.datagnostics.com/tips.html

(please reply to the newsgroup)