G
Guest
I am in the process of creating a database in which one of the forms has a
combo box, "cboProjectID", as part of a mainform, "frmSample". On the many
end of a one-to-many relationship is the field "SampleID" within a subform,
"frmSampleSubform". I am also placing either on the mainform or subform, a
form with an option group (radio buttons) so that users can print various
reports while in frmSample.
I'd like to avoid users having to enter the criteria in the form with the
option group, but rather have it reference what record is selected in
cboProjectID of the mainform and the SampleID field of the subform. How do I
go about doing this?...AND...Does it matter whether the option group is
located in the mainform or subform?
Thanks in advance for any suggestions/feedback!
combo box, "cboProjectID", as part of a mainform, "frmSample". On the many
end of a one-to-many relationship is the field "SampleID" within a subform,
"frmSampleSubform". I am also placing either on the mainform or subform, a
form with an option group (radio buttons) so that users can print various
reports while in frmSample.
I'd like to avoid users having to enter the criteria in the form with the
option group, but rather have it reference what record is selected in
cboProjectID of the mainform and the SampleID field of the subform. How do I
go about doing this?...AND...Does it matter whether the option group is
located in the mainform or subform?
Thanks in advance for any suggestions/feedback!