POPULATING MULTIPLE FORMS FROM COMBO BOX

[Sylvie]

I am creating a LAB report for my studies and found a thread one of the same
questions regarding a combo box, I followed the instructions, however is not
working.
Here are the tables:
tblStudy:studyID, studyname
tblSubject: subID,Subname,sponsor,studyID
Tblvisit: visitid, subjectid,dateofvisit
tbleREAD:READID,ReadDescrip
tbleRange:RangeID, RangeDescrip
tblLabRead:LabReadID, VisitID, REadID
tblLABReadRange:LabRangeReadID,LAbReadID

A- I built a form for tbleReadRange and used a combo box for the range
field(getting the list from range table)
B- Other form for tble LAb read using a combo for the field read field and
a subform under the read combo
C- Other form Visit adding the form as a subform.

Here is my dilemma:
1 - When enter subject name form is not getting name;
2 - I open form visit from subject form through a command button and the
visit is not filtering for the subjid;
3- lab read contains 15 diferents read whith 5 or more ranges, I need 15
combo box on the form, choosing the range from a list.

Should I have a tble for each read?

IF sound confusing let me know. Any help is VERY much appreciated.
Sylvie

 

[Sylvie]

For the dilemma #1 I inserted on Not In List event:
If Msgbox ("Nmae is not in List. Add it?", vbok cancel) = vbok then
DimstrSQL As String
strSQL = "Insert into Study Select """ & New Date & """;"
It worked well
I am trying to make a tbel for each read I think will be better!
TIA

 

[Author]

2 - I open form visit from subject form through a command button and the
visit is not filtering for the subjid;

I'm confused at "the visit is not filtering for the subjid;". What have you
entered on the form, and what is the end result you want? To find a visit
based on subjid, or is it something else? Follow this link to a download-
that might be what you're looking for:
http://www.techonthenet.com/access/forms/filter_form.php

Should I have a tble for each read?

Yes.
Your combo box gets the list of options from a table, so making a table for
each read is the only way I would know how to do it. There may be another
way, but I know it would work if you made a table for each combo box.