I am creating a scoring system to keep track of team scores during a quiz night.
I have three tables tblTeam, tblRound and tblScore.
A quiz consists of say 10 rounds
During a quiz a team cn play its Joker which doubles the Team score for that round only. A team can only do that for one round.
tblTeam has fields TeamID(Number PK), TeamName(ShortText), JokerRound (Number)
tblRound has fields RoundID(Number PK), RoundName(ShortText)
tblScore has fields ScorID(Number PK), TeamID(Number), RoundID(Number), Score(Number), Joker(T/F)
All Number Fields are Long Integer
Before the quiz starts each team has to register with a team name and the round they wish to play their Joker. I have created a continuous form to enter this detail. (frmTeamEntry). This works fine. This form's record source is tblTeam.
This is where I have got stuck with brainfreeze!
I want to write VBA event procedure for a button on frmTeamEntry to populate tblScore fields. I am familiar with using VBA and planned to use recordsets to achieve the population. But I just cannot fathom how.
All suggestions very, very welcome.
Many thanks
I have three tables tblTeam, tblRound and tblScore.
A quiz consists of say 10 rounds
During a quiz a team cn play its Joker which doubles the Team score for that round only. A team can only do that for one round.
tblTeam has fields TeamID(Number PK), TeamName(ShortText), JokerRound (Number)
tblRound has fields RoundID(Number PK), RoundName(ShortText)
tblScore has fields ScorID(Number PK), TeamID(Number), RoundID(Number), Score(Number), Joker(T/F)
All Number Fields are Long Integer
Before the quiz starts each team has to register with a team name and the round they wish to play their Joker. I have created a continuous form to enter this detail. (frmTeamEntry). This works fine. This form's record source is tblTeam.
This is where I have got stuck with brainfreeze!
I want to write VBA event procedure for a button on frmTeamEntry to populate tblScore fields. I am familiar with using VBA and planned to use recordsets to achieve the population. But I just cannot fathom how.
All suggestions very, very welcome.
Many thanks