P
Paul R in Oregon
Tables = tblIssue and tblManuscripts with one-to-many relationship
frmChooseIssuesDialog has cboFirstIssue and cboLastIssue combo boxes
based on one-field query on tblIssue
qry4subfrmDisplayChosenIssuesAndManuscripts queries tblIssue and
tblManuscripts and has following parameter under tblIssue.Issue field:
Between [Forms]![frmChooseIssuesDialog]![cboFirstIssue] And
[Forms]![frmChooseIssuesDialog]![cboLastIssue]
How do I get a sub form to display the manuscripts associated with the
issues in the range defined by the two combo boxes?
frmChooseIssuesDialog has cboFirstIssue and cboLastIssue combo boxes
based on one-field query on tblIssue
qry4subfrmDisplayChosenIssuesAndManuscripts queries tblIssue and
tblManuscripts and has following parameter under tblIssue.Issue field:
Between [Forms]![frmChooseIssuesDialog]![cboFirstIssue] And
[Forms]![frmChooseIssuesDialog]![cboLastIssue]
How do I get a sub form to display the manuscripts associated with the
issues in the range defined by the two combo boxes?