Hi June,
If I put the SQL statement in CboAccountSourceID, it works fine, stores the selection. if I put a WHERE condition in it to get only the AccountSource that is dependent on selection in CboAccountType, then it appears in the dropdown, but wont let me make a selection. Could it be possible that my WHERE clause is wrong? Just wondering...
Code:
SELECT [Tbl_AccountSource].[AccountSourceID], [Tbl_AccountSource].[AccountSource] FROM Tbl_AccountSource ORDER BY [AccountSource];
If I add WHERE
Code:
SELECT [Tbl_AccountSource].[AccountSourceID], [Tbl_AccountSource].[AccountTypeID], [Tbl_AccountSource].[AccountSource] FROM Tbl_AccountSource WHERE (((Tbl_AccountSource.AccountTypeID)=[Forms]![Frm_AccountMain]![CboAccountTypeID]));