Steve's suggestion certainly sounds like the solution to your immediate problem, but I have to tell you that your statement
Originally Posted by
batowl
...I needed to duplicate the table structure and forms for another subject within the same database so I copied the tables and forms within the database for this new topic...
almost assuredly means that your database is not Normalized! Instead of duplicating Tables you should have a Field that denotes the given subject, and pull up Records for a given subject by filtering the Form on this Field. Having multiple Forms based on a single Table presents no real problems, other than maintenance, if it makes for easier user interaction.
Linq ;0)>
The problem with making anything foolproof...is that fools are so darn ingenious!
All posts/responses based on Access 2003/2007