Good morning everyone.
I have a problem with two comboboxes of one mask.
The comboboxes are as follows:
-cbo_1
-cbo_2
A certain number of electronic devices can be selected in cbo_1.
The cbo_2 is "controlled" by the cbo_1 and when an electronic device is selected in the cbo_1 automatically in the cbo_2 there is only the company that sells this electronic device.
I know that for each electronic device there is only one company, so I would like to make sure that when I select an electronic device in cbo_1, cbo_2 is automatically updated without having to manually select the corresponding company.
I tried inserting a macro in the "AfterUpdate" event of cbo_1, but cbo_2.Requery is not enough, in fact I have to manually select the company from cbo_2.
How can I do ?
Thank you all.
Sorry for the bad English