I have a form containing 4 combo boxes. One combo box limits its values depending on the values selected in the other three combo boxes. What I want is to have a text box that displays the current number of values listed in that 1 main combo box. How is this done?
I tried modifying this code but the only number I could get is 1, or 817 (the total number of records available) if I removed the =combobox reference, no matter what filters have been applied. The modified code I used is:
Dim ComboCount as integer
ComboCount = DCount("[StuRecID]", "BaseData_qry", "[StuRecID]=Combo2")
Text71 = ComboCount
Can you see anything obviously wrong with this code.