As a general UI/UX rule whether in MS Access or other apps, no more than 3 or 4 subforms should ever be visible on the screen at the same time. Showing 5 or more simultaneously creates visual clutter, forces horizontal/vertical scrolling, and confuses the user's data entry flow.

For a Hockey Card collection, general industry solution is using a Tab Control. But I really hate it and strongly advise against using it. Because it loads all subforms simultaneously in the background, it can cause performance issues and screen flickering. Instead, in my opinion, the cleanest and most robust approach is to set up a Subform Container. Place a single, empty subform control on your main form. Add vertical navigation buttons on the left side, and when the user clicks a button, switch the container's SourceObject property using VBA (for example, Me.subContainer.SourceObject = "frmGrading"). This ensures you never have multiple subforms running at the same time, keeping your form responsive and lightweight.