Unless I'm missing something this code is doing exactly what you're asking.
If I select AA I get A1 & A2 in second combobox, Then select A1 in second combobox result in combobox1third combo) = 01A.
Code can be improved for performance on larger datasets but where is the problem ??