Combolistbox

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello, I'm using a combolistbox in my gamesstatistics form to fill in players
name. But because there are a lot of members I've made for each team a
selection of members. These selections change every year. The result of this
is that I do not see the names of the players who are not in this years
selection on the previous years forms. I can of course create a duplicate
gamesstatistics form with all players and one with a selection of players.
But is there a more charming solution?
This was also posted in new users group with no result so far
 
Hans* said:
Hello, I'm using a combolistbox in my gamesstatistics form to fill in
players name. But because there are a lot of members I've made for
each team a selection of members. These selections change every year.
The result of this is that I do not see the names of the players who
are not in this years selection on the previous years forms. I can of
course create a duplicate gamesstatistics form with all players and
one with a selection of players. But is there a more charming
solution?
This was also posted in new users group with no result so far
Click to expand...

I think your best bet is to add the year as a field to the TeamPlayers
table (or whatever you may be calling it). So you might have

TeamID, Year, Player
-----------------------
1, 2003, Hans
1, 2003, Dirk
1, 2004, Hans
1, 2004, Joachim

Then your form would have a control on it for choosing what year you're
interested in -- with a default value set to the current year -- and the
combo box's rowsource query would be set to select from the table only
those players for the year specified in that control. You would requery
the combo box any time a different year is entered on the form.
 
Back
Top