Filter subform with two combo boxes

[dotcanada]

Hi all.



First post on this forum. Not entirely new to access but still consider myself a novice and learning a lot.

I'm building a hockey player database which shows what team they're on and other stats. I'm created a form (frmTeamStats) which has a subform (in datasheet view) and two combo boxes on the main form. The datasheet lists the player, the season (ie 2014-15), and their stats. I would like one combo box to list of teams in the league and the second to filter the list by season. Is this possible?

Thanks in advance.

[ranman256]

In a continuous record form,.user clicks the team, cboTeam,
the data gets filtered in cboTeam_afterupdate event

me.filter = "[team]='" & cboTeam & "'"
me.filterOn = true

If you want to further filter year,

me.filter = "[team]='" & cboTeam & "' and [year] =" & cboYear 
me.filterOn = true

select a row, (player) , click the btnDetail button,
this will open the single record form to show the player details
docmd.openform "frmPlayer",,,"[playerID] = " & txtID

In a single record form,frmPlayer, an in the header is a combo cboYear
in cboYear_afterupdate event, you can filter the subform data with filter like above but be sure to use the path to the subform

[dotcanada]

Thanks for the quick reply.
I placed in the second coding for the combo box. But there is a bug. I've attached my dbase. The form I'm trying to work on is frmTeamStats. I'm sure there are a few mistakes within the dbase (relationships, etc.)

[ranman256]

I cant open standing. You have it connected to linked excel file which i dont have.
your forms should not be connected to excel files (for this reason)

Is your propblem in the PLAYER INFO button, or STANDINGS?

[dotcanada]

The Standings option is not an issue. It is with the frmTeamStats and getting the second combobox to work (cboSeason). The first combobox (cboTeam) currently works and brings up the the players and their stats, but I want to filter down the list according to the season.