This question came up in a recent Dynamics GP newgroup post
. A developer was trying to run some Visual Basic for Applications (VBA)
code in response to the company selected by the user from the Company drop-down list, but was unsuccessful determining which company was selected by the user.Challenges
From a customization and development perspective, the Company drop-down list presents the following challenges:
1) Different users may have access to different companies, therefore, the number of companies displayed by the drop-down may vary.
2) The company drop-down list does not store the company ID. It stores a positional value for the company record being displayed.
3) Companies are displayed in the drop-down by Company ID. However, due to…