Append Query Based On Yes/No

Hi, greeting, I'm new in the neighborhood...

I've been around basic Access for quite awhile (on an as needed basis), but have never developed anything significant...until now. I've looked through the forums here a little and did not readily find an answer to my question (probably because I'm not sure what I need to enter for a search). So here goes my question...

I'm creating an Access DB that can be use for tracking weekly scores in a league that I belong to. I've got the basic information layout and report generation taken care of (call it pre-beta, but it works). I'm slowly building in other functionality (I still have a ways to go and I'm sure I'll be posting more questions along the way).

As to the specifics, these are a few of the tables. The first table (tblRoster) is fairly static:
Field 1: IDNum (Primary Key)
Field 2: Name
Field 3-n: Other Stuff

Table 2 (tblScores) is added to each week:
Field 1: IDNum
Field 2: WeekNum (int reflecting which week in the league we are in: 1-n)
Field 3-n: Scores

There is a 1-many relationship keyed off of IDNum.

I have created frmScoreInput (using a query as a datasource filtered on WeekNum) that allows me to combobox pick an IDNum from tblRoster and then enter the corresponding scores on the fly (they come in in random order so there is a lot of jumping around). The problem is that I first need to pre-populate tblScores with the IDNum and WeekNum of the individuals that are competing that night. Not everyone competes in one night nor do all compete weekly (for some people are alternates), however all scores entered in the same week are evaluated together.

What I think will work best is to use our roll call procedure from a form (called frmPopScores) generated from tblRoster and if the person is present, place a check mark in a yes/no box which would then do an append query of the current IDNum & static WeekNum value to tblScores. (I was thinking that if I unselected the box, then the record would be deleted as well - but that could be a future mod).

I have run into three issues:
the yes/no box seems to need to be a part of a table which I didn't really need except to populate tblScores,when I click on the first yes/no in the input form ALL the yes/no's become clicked,and lastly, the proper syntax for the actual append placed somewhere under a Yes/No [Event Procedure].I don't have much sql background, but what I've gleened from this forum is I would do something like this:
dim valIDNum, valWeekNum
dim sqlstr
valIDNum = Me.IDNum
valWeekNum = Me.WeekNum
sqlstr = "INSERT INTO [tblScores] (ValIDNum, valWeekNum)
VALUES (valIDNum, valWeekNum)
docmd.runsql sqlstr
I also I know I have issues distinguishing between textbox values and field values as well as general non-sql knowledge, so my code may be hinky. Corrections would be appreciative.

Lastly, what would be a good intro Access book. I'm currently borrowing Access 2002 Inside Out by MS Press. It seems to be a decent reference if you know what you want. Is there a good "beginner" book for getting your hands wrapped around Access?

Thanks for any assists.

-Joat.