Data Enry Forms

[Robert Meir via AccessMonster.com]

I have 24 company tables. I need to create a data entry form for each.
All the tables use the same fields. Is there a way to use one(1) data
entry form for all table and populate the header with the table name of the
table in edit?

I'm just thinking that when the user clicks on a button for company1 the
data entry form would populate with company1 record data. And when the user
clicks on company2 button, the data entry form would populate with company2
record data, but the header would show a different company name.

Any suggestions???

Thanks,
Robert

 

[Rick B]

Just curious, why do you have 24 tables if the structure is identical? Why
not just add a "company" field to the table?

 

[Klatuu]

Is there a specific reason you need 24 tables since the table layouts are
identical? It would be better to add a field something like [Company_Code],
give each company a code in the table, then have your form filter on
[Company_Code].

 

[Robert Meir via AccessMonster.com]

Thanks Rick and Klatuu. You've added value to my very hectic day. You're
right. I could put all the tables in one table and use the one data entry
form with a company name code as the flag.

Thanks again!!

Robert