Hello all.
I took over working on an Access database.
It's a facility phonebook listing.
Each location has it's own table, and then also 2 forms, a "main form" and a subform. The subform is basically the table in a dataset view, and the main form has a search function and some other information.
An overall navigation form is used to organize the layout.
But here's my question, how would I be able to make it so I can use same form and/or subform to open the correct table when the button for that location is clicked. That powers that be want to maintain the look of it, with the main location tabs at the top and then under each of those the facility tabs that open the phonelisting for each.