Can I update a query based on the tab that is selected

Hi Paul,

Here is an example of using only one subform. You will notice that I haven't even placed it on the tab as you would need to have 12 subform controls and only one would be used at the time (for the current tab).
As for the departments you should only have one form as well and maybe control it from a combo box to filter the selection.

Cheers,
Vlad
 

Attachments

you don't like minimum viable product? not sure if best use of the term in this case - minimum viable database - MVD maybe

P
 

Users who are viewing this thread

Back
Top Bottom