Populating a sub form

[claff319]

I was wondering if it could be possible to populate all the players from a team to a subform for a softball statistical database..My tables are currently set up as follows:

Player: (playerID, teamID, playername, etc)
Team: (teamID, leagueID, teamname, etc)
League: (leagueID, name, etc)


Games: (gameID,Date,Time, teamID 1, teamID 2)
Season: (seasonID)
HittingStats: (playerID, gameID, seasonID, PA, 1B, etc)

Currently i have a set of dynamic combo boxes. After the user chooses which league the team is associated with, the Team combo box re-queries to the teams specific to that league. From there i was wondering if it is possible to populate a subform with the players that are specific to that team picked within the combo box. The subform is for the teams hitting stats, which would populate the subform with all the players on that team, allowing the user to just input the stats and not worry about inputting every single playerID. Thanks for the help!

[June7]

Why do you have a subform? What is its relationship to main form? Are Master/Child properties of the subform container set? Filter main form to a team and the subform of related players will synchronize. If there is no linking between main and sub forms, apply filter to subform. Can use expression in Filter property of subform [TeamID] = Forms!mainform!listbox, then have code in list or combo box AfterUpdate event to toggle FilterOn property.

[rpeare]

Why would you want to do this when members of a team may not play (injured, didn't attend, didn't play, etc) Wouldn't you end up with a bunch of blank data during the course of a season?

What you're asking to do can be done you'd just have to perform an append query once your team was chosen that added all the records to your stats table then refreshed the contents of the subform but it's not a very good practice.