first i would look at my attachment to see my table structure and relationships.
there are 20 questions in tblQuestion, i want the user to open a form, enter the caseno, click a button and a subform (control source = tblMain) will poulate with the 20 questions. then my users can add their answers.
this all sounds so simple yet i havent a clue on how to go about doing this, would i need to use a query?
i hope i have made my problem clear, does anyone have any advice or solutions?
INSERT INTO tblMain (CASENO,QUESTIONID, ANSWER)
SELECT parCASENO as CASENO, tblQuestions.QuestionID, Null as ANSWER
Private Sub ctlSelectCaseNo_AfterUpdate()
Dim dbs as DAO.Database
Dim qdf as DAO.QueryDef
Set dbs = CurrentDb
Set qdf = CurrentDb.QueryDefs("qryAddQs")
'This will add any missing questions to the Case
.Parameters("parCASENO") = ctlSelectCase
set dbs = Nothing
Me.Filter = "[CaseNo] =" & ctlSelectCaseNo
Me.FilterOn = True