P
Pat
My database is going to be used to limit the number of records
retrieved by selecting a series of combo boxes. The tables I am using
contain parts of number i.e. Audit table contains Audit_Num: OIG-05-36,
Recommendations table contains Recommend_Num: OIG-05-36-1; Milestones
table contains Milestone_Num: OIG-05-36-1-2. So the entire number is
OIG-05-36-1-2, the base being Audit and growing into Milestone. I
would like to set up a form that limits the records in each combo box
based on the selection of the parent combo box. So if I selected
Audit_Num OIG-05-36 it only returns (in the Recommend_Num combo box)
those records that are associated with that Audit_Num. And the same for
the Recommend_Num combo box only selecting the Milestones records that
are related. But I would like the Milestones in a subform on the same
form. Can you please help...
retrieved by selecting a series of combo boxes. The tables I am using
contain parts of number i.e. Audit table contains Audit_Num: OIG-05-36,
Recommendations table contains Recommend_Num: OIG-05-36-1; Milestones
table contains Milestone_Num: OIG-05-36-1-2. So the entire number is
OIG-05-36-1-2, the base being Audit and growing into Milestone. I
would like to set up a form that limits the records in each combo box
based on the selection of the parent combo box. So if I selected
Audit_Num OIG-05-36 it only returns (in the Recommend_Num combo box)
those records that are associated with that Audit_Num. And the same for
the Recommend_Num combo box only selecting the Milestones records that
are related. But I would like the Milestones in a subform on the same
form. Can you please help...