I am using the following command after a user selects a combo box for an item and I want the person related tot that item to be updated through a different combo box, the command I am using is;
DoCmd.DoMenuItem acFormBar, acRecordsMenu, 5, , acMenuVer70
I put this in the After Update on the first combo box and I tried it on the On Got Focus and they both work fine except there is a 5 - 10 second delay before the 2nd combo box populates. Any ideas on how I can make the second Combo Box populate faster?