Unselect default value in combobox based on dropdown (sql connection)
I have a canvas app with a SQL connection. The create and edit controls are placed on one screen and the visibility of the controls is handled by a variable.
I have a combobox named cmboOwner. This combobox depends on the selections made in dropdowns A and B (dropdown B depends on the value selected in dropdown A). When a user is in edit mode, existing data (=OwnerName) for a specific record is shown in cmboOwner. When a different value is selected in B, I want the default value in the cmboOwner to be "unselected" because the possible OwnerNames differ per value selected in B (so, in this case the pre-selected value shown in cmboOwner is incorrect, but the correct values are shown when expanding the dropdown). I've been at this for a few days with no success. How can I get the default value to get unselected when a different value is picked in dropdown B while being in edit mode? Is this possible?