D
dgreen
I have a form that displays projects with a sub form to display letters
(email) associated to each project. The projects are displaying but the
letters are not.
form1 queries for projectid, project_description, phaseid,
phase_description, processid, process_description. form1 source is a query
that queries for these fields. projectid, phaseid and processid are in
separate tables with their respective descriptions (projectstbl, phasetbl,
processtbl).
subform form2 should query letters based on projectid, phaseid and
process_id from main form but doesn't. form2 source is a query based on
projectid, phaseid and processid from form1. The fields displayed in form2
are from lttrstbl.
Form1 has scroll bar that steps through all the projectids with their
associated info. No records are displayed in form2 while steping through
form1. Nothing is displayed in form2.
Here are the criteria for form2 query:
[Form]![QueryProjectPhaseStage]![Projid]
[Form]![QueryProjectPhaseStage]![Phase]
[Form]![QueryProjectPhaseStage]![Stage_of_process]
What do I need to do to get this to work?
Thanks in advance for your help!
(email) associated to each project. The projects are displaying but the
letters are not.
form1 queries for projectid, project_description, phaseid,
phase_description, processid, process_description. form1 source is a query
that queries for these fields. projectid, phaseid and processid are in
separate tables with their respective descriptions (projectstbl, phasetbl,
processtbl).
subform form2 should query letters based on projectid, phaseid and
process_id from main form but doesn't. form2 source is a query based on
projectid, phaseid and processid from form1. The fields displayed in form2
are from lttrstbl.
Form1 has scroll bar that steps through all the projectids with their
associated info. No records are displayed in form2 while steping through
form1. Nothing is displayed in form2.
Here are the criteria for form2 query:
[Form]![QueryProjectPhaseStage]![Projid]
[Form]![QueryProjectPhaseStage]![Phase]
[Form]![QueryProjectPhaseStage]![Stage_of_process]
What do I need to do to get this to work?
Thanks in advance for your help!