Can I update a query based on the tab that is selected (1 Viewer)

bastanu

AWF VIP
Local time
Today, 01:49
Joined
Apr 13, 2010
Messages
1,401
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

  • Database6.zip
    241.6 KB · Views: 131

cowenpa

Member
Local time
Today, 08:49
Joined
Apr 7, 2021
Messages
38
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

Top Bottom