Trigger to Select one Field Undesirably Deselects another Field
Here is my issue, I have one "hub" tab where one selects the type of business they would like to look at, I have other "spoke" tabs containing charts of specific accounts.
On the "spoke" tabs I have triggers that automatically select a specific account within the "Account" field when the tab is acivated and deselect "Account" when the sheet is deactivated.
For some reason, when I select a type of business from the "Business" field on the "hub" tab and then go to one of the "spoke" tabs, "Business" gets deselected. I checked and I do not believe that this is caused by the selections having no overlap.