Combo box not displaying but is saving to the table

[CT_AccessHelp]

Good Morning,



I have a combo box that should be displaying a list of codes based on the selection of fund types in another combo box. If I select somewhere in the "Sub_BOC1" combo box that is not displaying the list of codes it saves a record in the table. Any Ideas why this is happening? I have provided a picture of the form and code, hope it helps. Thank you!

The row source for the combo box bound to the field "CNTY" Code:
SELECT DISTINCT County FROM tbl_Accnt_code ORDER BY County

In the after update event of the combo box CNTY Code:
Private Sub County_AfterUpdate()
Me.Accounting_Code.Requery
Me.Accounting_Code.Value = Null
Me.Accounting_Code.SetFocus
End Sub

And the row source for the "Accounting_Code" combo box Code:
SELECT [AccountingCode] FROM tbl_Accnt_code WHERE [County] = Forms!frm_Expend.CNTY ORDER BY [AccountingCode]

NOTE: THE CODE ABOVE WORKS FINE.


The row source for the combo box bound to the field "Fund" Code:
SELECT DISTINCT Fund_Type FROM tbl_Fund_Type ORDER BY Fund_Type

In the after update event of the combo box Fund Code:
Private Sub Fund_AfterUpdate()
Me.SUB_BOC1.Requery
Me.SUB_BOC1.Value = Null
Me.SUB_BOC1.SetFocus
End Sub

And the row source for the "SUB_BOC1" combo box Code:
SELECT [SUB_BOC] FROM tbl_Items_BOC WHERE [Fund_type] = Forms!frm_Expend2.Fund ORDER BY [SUB_BOC]

[June7]

Try:

Give the Fund combobox a name different from the field, like cbxFund, then:

SELECT [SUB_BOC] FROM tbl_Items_BOC WHERE [Fund_type] = [cbxFund] ORDER BY [SUB_BOC]

[CT_AccessHelp]

Thank you, I tried it and nothing changed, it is still not displaying the list.

[June7]

I've had comboboxes corrupt. I had to delete and recreate.

If you want to provide db for analysis, follow instructions at bottom of my post.

[CT_AccessHelp]

Thanks I have attached a copy.

[June7]

The SUB_BOC1 combobox RowSource has only one field. Change properties:
RowSource: SELECT [SUB_BOC] FROM tbl_Items_BOC WHERE [Fund_type]=[Fund] ORDER BY [SUB_BOC];
ColumnCount: 1
ColumnWidths: 1"

Set the Fund combobox RowSource to:
SELECT Fund_Type FROM tbl_Fund_Type ORDER BY Fund_Type;

When you changed the Fund combobox name, need to change the event procedure name. Just change the name back to what it was.

Why doesn't the CNTY combobox pull RowSource from tbl_fsacnty_mn?
SELECT County FROM tbl_fsacnty_mn ORDER BY County;

Suggest the combobox requery be in the GotFocus event instead of AfterUpdate so that if user goes to the combo without changing Fund, the RowSource will filter properly:
Private Sub SUB_BOC1_GotFocus()
Me.SUB_BOC1.Requery
End Sub

Do similar for Accounting_Code:
Private Sub Accounting_Code_GotFocus()
Me.Accounting_Code.Requery
End Sub