Forum Discussion
Adding sub form for a new year
You open the form in design view, add a new tab by right-clicking the tab control, then copy the previous subform, select the new tab, and paste.
That said, think what this will look like in 10 years. So many tabs I would get dizzy. Plus, what if you win the lottery in year 5 and there is nobody available to do this annual maintenance? It would be much better to have a single tab for Dues, listing all dues. Perhaps there would be two text boxes to allow filtering for a date range. The big advantage is that this will work indefinitely, without any annual maintenance needed. Highly recommended.
Thank you so much. Great idea. Now I need help in how to implement your idea. This is my 3rd time trying to reply to your post. It disappears.
I like your idea. Thank you. However, I have no idea how I would do that. Any help would be greatly appreciated.
Design the form, and inspect the subform for the most recent year. What is its Recordsource property? Is the Filter property set?
But before we go down this road: please lay out all your tables on the Relationships diagram (see Database tools tab in the Ribbon), and post a screenshot here. We want to convince ourselves that you have a solid database design.
