Adding sub form for a new year

The reason you are running into trouble is the design itself. Having a separate subform and usually a separate table for each year is what creates the problem. I see people do this all the time with things like sales tables - Sales2024, Sales2025, and so on - but that really should all be one table. The same applies here with your dues.

What you really want is one Dues table with fields like MemberID, Year, AmountPaid, DatePaid, MailingFeePaid, and so on. That way every year's dues go into the same place. Then on your main Membership form you only need one subform that lists all the dues for that member. If you want to see a specific year, just add criteria to filter by Year. That makes the database simpler, easier to maintain, and it will keep working indefinitely without you having to add a new tab every year.

If you already have tables for each year, you can copy them into one combined table, just adding the year as a field. Once it is set up, you never have to redesign the form again. It is a one-time fix that saves a lot of headaches down the road.

I actually did a TechHelp video on something very similar to this because my students ask me about it all the time. The question I usually get is "how do I reset the database for a new year?" The answer is the same idea - you do not create a brand new table or form for each year, you design the database once with the year as a field and then just filter the data you want to see. Here it is: Reset an Access Database for the New Year.

Let me know if that helps.

LLAP
RR