In the form, frm_TrainingByEe, I have three tabs. The first two have four combo boxes each. I would like to have:
Tab 1: Skills: Shifts and Banks
Bank combo independent of Shift combo, if Shift combo is not populated.
This is how it is now. I can leave the shift blank, select Bank B, and the Report will be for Bank B AM and Bank B PM.
How can I retain this option for when Shift is not populated, but requery the Bank combo box if the Shift combo box is populated? Then if AM is selected, only the banks on the AM shift will be in the Bank combo box.
I need the same structure for Workload and Queue. That is, Queue independent of Workload, but dependent on Workload if workload is populated. They are connected on the Skills table.
I think I can figure out the settings for tab 2 if I get these first two.