I have the following code, which changes the items in the listbox depending on another box in the form.
Form.RecordSource = "CreditControllerSpecific"
combo_CostCentreLevel.RowSource = "SELECT 'All Profit Centres' FROM Structure UNION SELECT DISTINCT CostCentre FROM tblCostCentres WHERE CreditConName ='" & cmb_CredConName & "'"
'
The rowsource works correctly but it doesn't refresh itself when I select something else in the other box.
Is there a way to reset the index back to 0 ?
Form.RecordSource = "CreditControllerSpecific"
combo_CostCentreLevel.RowSource = "SELECT 'All Profit Centres' FROM Structure UNION SELECT DISTINCT CostCentre FROM tblCostCentres WHERE CreditConName ='" & cmb_CredConName & "'"
'
The rowsource works correctly but it doesn't refresh itself when I select something else in the other box.
Is there a way to reset the index back to 0 ?