Multiple Form Copy reference Issue

[gymcshoe via AccessMonster.com]

Hello all,

I have 5 tables all identical, just the data differs. I created a somewhat
complex form for table 1. Because form 1 for table 1 is complex and thus
tedious to replicate, is there an easy way to copy form 1 four times to be
used to access tables 2-5, respectively?

I tried copy and pasting everything in form 1 to form 2 that is linked to
table 2 but I get reference errors: form 2 keeps looking for fields from form
1.

Thanks!

 

[gymcshoe via AccessMonster.com]

Sorry answered my own question. I had charts on my form and they were causing
the reference errors. Thanks

 

[Klatuu]

Your real problem is your database design. You should not have 5 identical
tables with different data. They should all be one table with a field to
identify to which group each record belongs to. Doing it the way you are
doing it will cause not only the problem you are now having, it will
complicate everything else you want to do.