Show a subform based on one OR another ID

[Dan.w]

I have a form for player information for players in a board game group I am part of. I would like to have a sub form that lists all documented games that player has been apart of. The gamesTable lists player1ID and player2ID. I want the sub form to show all games where player1ID OR player2ID = form playerID. I have done quite a bit of access in the past, but I am a good 3 years removed now. Any help here how I may do this?

[Rod]

Do you want one subform that mixes player1's games with player2's or do you want two subforms, one for player1 and one for player2?