I have two comboboxes, in the first one the user selects the company and based on the company selection the user chooses which branch of the company in the second combobox.
How do I go about making it so by default the second combobox auto selects its first branch? I need to do this so my subforms will populate without having to select the branch, unless the user needs to change it.
However, the second combo box does show the first item in the list, but it does not update the subform that the second combo box is linked to.
Any ideas on fixing that?
Thank you so much for your help so far,
To clarify, I have to still click the down arrow on the combo box and reselect the address to get the subform to update. Is there anyway I can get the subform to update after the first combo box is selected, based on the second combo box's data?