Forum Discussion
Adding sub form for a new year
I am new to access. I have a new job to work on the database. I am attaching a copy of the page where there is the membership record and below there are several subforms. I would like to add a new ...
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.