Tabbed form accessing separate tables??

[Jasontm01]

I have a database that has 10 tables. Each table has the same fields but for 10 different locations.

I would like to build a form with tabs with 1 tab for each location (table)

Is it possible to get the tabs to show data from a specific table? Would I have to build separate subforms for each table or could I have one set of fields and have it update the dataset based on which tab they are on??

Thanks!

 

[a.sinatra]

Umm, maybe you should first get your tables right, there is no reason to have 10 of the same tables.
________
Vaporizer Instructions

 

[Jasontm01]

The data comes from 10 different locations and does need to be kept separate. The tables do have the same fields in them but thats really not relevant to the question I guess.

 

[Jasontm01]

That would require editing data that already exists. I can add a location field but how can I get it to populate it for me. I cannot type it in manually as there are far to many records.