On my Main form, I have a Combo Box which gives the user 3 choices of data to see. When the selection is made, a list box populated with this appropriate query for the selection. At the same time, the subform becomes visible with the corresponding (to combo box selection) tab visible with the specific data for the selection in the query.
I have no issue with hiding/showing the proper tab to match the combo box selection under normal maneuvering. However, the subform does contain a couple fields that are editable. If goes directly from editing a field to changing the combo box, that subform tab remains visible, as well as the new selection.
If the user makes subsequent moves, the tab will hide.
How can I avoid this confusion for the user?
I have no issue with hiding/showing the proper tab to match the combo box selection under normal maneuvering. However, the subform does contain a couple fields that are editable. If goes directly from editing a field to changing the combo box, that subform tab remains visible, as well as the new selection.
If the user makes subsequent moves, the tab will hide.
How can I avoid this confusion for the user?