K
Kevin
It's march madness season, and I've designed an access DB to keep track
of brackets for a friend of mine running a pool. This is the basic
setup. I have 3 tables - Teams, Games, and Players. Teams lists the
teams in the tournament. Games is the master list of winners. This
table has each game individually numbered. Players lists each player,
and their picks for each individually numbered game. I have a form for
the master bracket, showing the actual results of the games. Winners
are chosen from combo boxes which get their values from the Teams
table. Then there is a form which shows the picks for each person in
the pool. This form uses the same type of combo box. Each player's
recordset shows their own bracket picks.
I was playing around with conditional formatting to change the color of
a person's picks depending on if the picks matched the winners in the
master bracket. To do this I needed to have a macro open the Games form
in hidden mode. Each combo box on the players form is set with
conditions to compare its value with the value of the corresponding
combo box on the Games form. So, if the teams match, the box is green,
if they don't, the box is red. This works fine for formatting games as
they have occurred, but they do not color future games because there
are no values on the Games form because there are no winners for the
future games. I want the Players form to show red for future games when
that team has already lost. For example, if someone has a team going to
the Finals, but that team loses in the first round, I want that team to
show as red from that point forward in the person's bracket. It just
helps visually to see if a person is basically out of the running.
Any thoughts on how to do this? I was trying to code changing the
backcolor of the combo boxes based on the values earlier in the
player's bracket, but I'm not adept at coding, and its not working.
of brackets for a friend of mine running a pool. This is the basic
setup. I have 3 tables - Teams, Games, and Players. Teams lists the
teams in the tournament. Games is the master list of winners. This
table has each game individually numbered. Players lists each player,
and their picks for each individually numbered game. I have a form for
the master bracket, showing the actual results of the games. Winners
are chosen from combo boxes which get their values from the Teams
table. Then there is a form which shows the picks for each person in
the pool. This form uses the same type of combo box. Each player's
recordset shows their own bracket picks.
I was playing around with conditional formatting to change the color of
a person's picks depending on if the picks matched the winners in the
master bracket. To do this I needed to have a macro open the Games form
in hidden mode. Each combo box on the players form is set with
conditions to compare its value with the value of the corresponding
combo box on the Games form. So, if the teams match, the box is green,
if they don't, the box is red. This works fine for formatting games as
they have occurred, but they do not color future games because there
are no values on the Games form because there are no winners for the
future games. I want the Players form to show red for future games when
that team has already lost. For example, if someone has a team going to
the Finals, but that team loses in the first round, I want that team to
show as red from that point forward in the person's bracket. It just
helps visually to see if a person is basically out of the running.
Any thoughts on how to do this? I was trying to code changing the
backcolor of the combo boxes based on the values earlier in the
player's bracket, but I'm not adept at coding, and its not working.