Text box with control source

[newkid]

Hi All!
I have a form with a data source as a table.
On the form the user selects a combo box which is tied to a query
selecting the account holder. I have a text box that references the
column in the comb box for ID.

The second combo has a controls source and a row source which is a
query.

Here's my delima:
I have a text box that has a control source and a default value from
the second combo box referencing the column number. It doesn't
populate after the combo box is updated. If I take the control source
off, it works. If I change it to a combo box with a controls source,
it works.

I need the text box to be tied to the controls source because I don't
want the user to select the account type.

Here's my query for the second combo box. I'm make a left outer join
and the account number from the second table to be null because I
don't want to show the accounts that have been used.
SELECT Accounts.[Account Number], Accounts.[Customer ID], Accounts.
[Holder ID], Accounts.[Account Type], BalanceAccount.AccountNumber
FROM Accounts LEFT JOIN BalanceAccount ON Accounts.[Account Number] =
BalanceAccount.AccountNumber
WHERE (((Accounts.[Holder ID])=[Forms]![frmBalanceAccount]![HolderID])
AND ((Accounts.[Account Type])=[Forms]![frmBalanceAccount]![txtType])
AND ((BalanceAccount.AccountNumber) Is Null));

I could really use some help with this one. Thanks

 

[newkid]

Hi All!
I have a form with a data source as a table.
On the form the user selects a combo box which is tied to a query
selecting the account holder. I have a text box that references the
column in the comb box for ID.

The second combo has a controls source and a row source which is a
query.

Here's my delima:
I have a text box that has a control source and a default value from
the second combo box referencing the column number. It doesn't
populate after the combo box is updated. If I take the control source
off, it works. If I change it to a combo box with a controls source,
it works.

I need the text box to be tied to the controls source because I don't
want the user to select the account type.

Here's my query for the second combo box. I'm make a left outer join
and the account number from the second table to be null because I
don't want to show the accounts that have been used.
SELECT Accounts.[Account Number], Accounts.[Customer ID], Accounts.
[Holder ID], Accounts.[Account Type], BalanceAccount.AccountNumber
FROM Accounts LEFT JOIN BalanceAccount ON Accounts.[Account Number] =
BalanceAccount.AccountNumber
WHERE (((Accounts.[Holder ID])=[Forms]![frmBalanceAccount]![HolderID])
AND ((Accounts.[Account Type])=[Forms]![frmBalanceAccount]![txtType])
AND ((BalanceAccount.AccountNumber) Is Null));

I could really use some help with this one. Thanks

Does anyone know the answer?