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 ...
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.