Subform - two different tables

[scottemotive]

Hi,

I have a tblMaster and tblScreeningForm and a frmMaster and frmSubMaster

tblScreeningForm has questions such as salutation complete? etc...
frmMaster has name, dept. etc.. that is stored in tblMaster,
what i want is to have a frmSubMaster inside frmMaster as a subform
frmSubMaster will show the questions stored in tblScreeningForm, and also when these questions are answered (yes/no) the values are stored in tblScreeningForm

I want the ID from frmSubMaster stored in tblMaster so that the following scenario would apply


tblMaster captures agent name etc... Sub form would display the questions,
when tblMaster goes to nextrecord the subform is stored in tblScreeningForm and is cleared for the next assessment, also frmMaster is cleared.
When going back to the records i want it to show agent name and the answered questions for that agent.

hope this makes sense.

can anyone sugest a method
your help is appriciated

thank you

Scott