I attached a very basic database that has two combo boxes that are populated by querying specific criteria in a table. The first combo box is Me.cboZone, the second combo box is Me.cboArea. Me.cboZone must be selected first to generate a list of options for Me.cboArea to select.
Currently, I select the first option in Me.cboZone. Then I individually select all the corresponding options in Me.cboArea that are associated with what’s displayed in Me.cboZone to execute a given task.
So the manual steps would look something like this in my database:
For Me.cboZone select the first record which is: ‘Atlantic’. Then for Me.cboArea select the first record which is ‘MD’ and perform task (e.g. MsgBox “Task complete”). Next for Me.cboArea select the next record and perform task. Then keep select all the applicable records in Me.cboArea until the end, then select the second record in Me.cboZone, and do the same thing all over again until complete.
There has to be a block of code that could automate this process, but I’m not strong enough with loops to put it together. I’d really appreciate a solution for this.