help using subform to add new record...

M

megansny

Hi all,
New at this... Need to create a database for a literature review of
research projects. Currently have tables tblStudyMain (for author,
date, etc, with PK study id#) ,tblExplanatory (for all possible
variables considered in the projects, PK var id#), and tbl_Study_Expl
with fields SEID (PK), StudyID, VarID to link the other 2 tables.

The projects have 1-26 possible variables. I would like to put a
subform in my main data entry form (formStudy) with a multi select list
box that will create a new record in tbl_Study_Expl for each item
selected, for each study, so that tbl_Study_Expl will end up like this:

SEID StudyID VarID
1 1 3
2 1 4
3 1 21
4 2 1
5 2 4 ....and so on.

I have tried a few suggestions that were offered in previous posts with
no success. Using Office2k.

Thanks for your help!
 
Top