Filtering data info on a Form

[Crackers]

I have a Table that contains names of Players for a football league and relevant information pertaining to their football.
I would like some advice on how to Filter certain information on a form that will call up only those Players that fit the criteria.
The 2 pieces of criteria that must be met are the name of the 'Club' that the player plays for and the 'Age' group that the player falls into.
I am unsure if I use Drop down boxes or Combvo boxes or what.
Could somebody please advise me on the correct method required. My knowledge on coding is not extremely deep.
Below is a sample of what I am trying to attain.

Player Club Age
P.Smith Melbourne 15
D.Evans Richmond 13
F.Allen Essendon 13
T.Waton Essendon 13

So from above I would like to call up all Players from Essendon, aged 13 along with other fields in the table that I need to view pertaining to those players.

Any help in this matter would be greatly appreciated.

 

[IfButOnly]

There are too many variables to say for sure what you best approach should be - but we will have a go.

For selecting the club - use a combo or listbox depending on the number of clubs. A listbox is good if you are only using a dozen clubs and you can show then all at once. if you have a lot of clubs, use a combo (drop down) as this gives you less screen clutter and also the added benefit of autoselection.

For the age group - if you only have a few groups then consider using an option group, otherwise as for the clubs.

you will want a list box for the selected items with at least some of the additional information. The rowsource for the listbox should obtain info from the club and age fields - eg Criteria for Clubs would be = Forms!formname!comboboxname.Column(0).

On the AfterUpdate event for your club and age group, do a requery on the listbox - Me!listboxname.requery.

I think I have made this sound more difficult than it is - give it a go, and advise of any problems.

Regards and Seasons greetings

 

[Crackers]

Thank-you

Thank-you very much, that worked perfectly