Hello fellow VBA programmers. Here's the issue. Any ideas ?
-------------------------------------------------------------
1. For .... Next loop in On_Current event ( 0 to 2 ) on Main Form.
2. This is for 3 combo box outputs, ( outside the recordset fields - of main form's recordsource )
3. Using navigation buttons on form - code outputs to them one by one and jumps to the 'After_Update' evnt for each - returning to the loop having done so.
4. When selecting a record ( Client ) using Combo Box ( .FindFirst " Client_ID" = cboBox.Value ), it output the FIRST ONLY of the 3 combo boxes, in loop, and jumps immediately to end of function. i.e No 'After_Update' event, and then, not processing other two Combo Boxes. Hope this makes sense. I'll let you know if I solve it, before I get any suggestions/explanations.
-------------------------------------------------------------
1. For .... Next loop in On_Current event ( 0 to 2 ) on Main Form.
2. This is for 3 combo box outputs, ( outside the recordset fields - of main form's recordsource )
3. Using navigation buttons on form - code outputs to them one by one and jumps to the 'After_Update' evnt for each - returning to the loop having done so.
4. When selecting a record ( Client ) using Combo Box ( .FindFirst " Client_ID" = cboBox.Value ), it output the FIRST ONLY of the 3 combo boxes, in loop, and jumps immediately to end of function. i.e No 'After_Update' event, and then, not processing other two Combo Boxes. Hope this makes sense. I'll let you know if I solve it, before I get any suggestions/explanations.
