Forum Discussion
Adding sub form for a new year
I see a some things in this screen shot that make me want to know more about the history of this particular database.
First, the image and design of this form remind me what we used to see in the early 2000's, with Access 2003 era databases. Is this one that old?
Second, the record selector shows 1 of 1843. I assume that would refer to the number of members, which is rather small for a database as old as this appears to be.
Third, the implication of having tabs for different years of dues is that the underlying design might not be appropriate.
Does this database have different tables for each year's dues, in addition to the subforms? As Tom said, all those subforms is going to lead to their own problems, and if there are also multiple tables, it's even more sketchy.
All in all, the impression created by the screen shot and desription is that this is an older database in need of tender loving care to make it more viable.
Show us, please, the table relationships in this database.