Hello,
I am working on an access database and I have created a form with three drop down boxes among several others. The first combo box is a called issue type and it has the options exception and re-pick in the drop-down. The second and third combo boxes are titled ‘Exception reason’ and ‘Re-pick reason’ respectively.
Now, if I choose exception in the first combo box, I want the 2nd combo box, exception reason, to become active while the third combo box, ‘Re-pick reason’ stays inactive. If I select re-pick in the first combo box, I want the exception reason combo box to become inactive and the re-pick reason combo box to become active.
I know I need to write a code in VBA but I am not able to get it to work. Can someone kindly give me the right code to make this work.
With Best Regards,
Ram.
