Insert values into table automatically - with Null values

[Guest]

Hi, I need some help. I am trying to make a form (for a review of an
application for a facility operation) that will display a subform checklist
that has checkboxes for a reviewer to enter checks. The subform is connected
to the main form by SWNumber. In the subform, I have been able to show only
the questions (and checkboxes) that I type into the table ReviewerResponse
because I also type in the SWNumber repeatedly for each question row. My
problem comes when I have, for example, 4 SWNumbers in tblApplication and I
want these 4 numbers to populate tblReviewerResponse for each of the 6
questions - so that the table will automatically show 24rows of questions -
and not stop at the null values in tbl ReviewerResponse
I have 3 tables (I left out the other non-essential attributes):
tblApplication
SWNumber PK

tblReviewerResponse
SWNumber PK
ChecklistItemID PK (both are concatenated keys)

tblChecklistQuestions
ChecklistItemID PK
ChecklistItemText

I was told to try to "insert" rows with a condition 'when ChecklistItem is
Null' and get Access to run a macro to do the insert. I really have no clue
how to change my relationships to get this to work and no VBA knowledge. I
also was working on making a form (this I think I can handle) for the user to
input a new site/facility ( using a new SWNumber). Maybe, on the user
inputting a new SWNumber it would initiate the actions I need.. Please offer
any help, it would be greatly appreciated.
Oh my tables have referential integrity and are joined one to many.

 

[Guest]

I meant to say that the null values seem to prevent the insert