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.

 

[Pat Hartman]

It is relevant because you don't need 10 tables to keep the data separate, you only need a location field in the one table. Then when you need to see data for only a single location, you would use a query with a parameter. Using this method, you need only a single form and your whole application becomes simpler. All of your forms and reports should be based on queries anyway so this doesn't even add any extra work.

To change the location that the form is showing, add an unbound combo. If you use the wizard, it will do the whole thing for you. Just be sure to choose the correct option.

 

[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.

 

[Pat Hartman]

Create 10 append queries that select data from the existing table and append it to the new consolidated table. Populate the location field with a literal value such as "Location1".