Subform connected to a form

[andrew456]

I have created a database to hold information about a tennis club.
It holds players details, and then has seperate tables to hold information about competitions.
Each player has a unique ID, and so do each of the competitions.
The players can be in up to 4 competitions, and I have it so that each competition knows who is in that competition (ie stores a list of each of the player IDs that are in that competition).
Hoewever, I have reached a brick wall when using a subform, having never used them before them before.

I want a form that has a dropdown box showing each of the competitions.
When a competition is selected, a list of the players in that competition is displayed, and when a player in that list is selected, their details are displayed on that form.
I guessed that a subform was the only way to do it, as I cannot think of any other way to do it...
However I'm also stuck on the subform!

Any help would GREATLY be appreciated.
Thanks..
Andrew

 

[jmrSudbury]

The list of players is the easy part. getting the player's information to show is harder since a list (tabular) form cannot have a subform. I would get the program to pull up a separate form to show the player's information.

Start by making all 3 forms then drag and drop the players list to the competition (columnar) form. Then on click or on double click of the player get the vba subroutine to open the player info form using a filter.

John M Reynolds