In the attached database, I have a main form with 3 inter-related subforms.
On the 2nd subform (Collection
) you select a Company.
On the 3rd (Collect Raw Material
) you select a Raw Material from a dropdown. This dropdown is dependent upon the value of the Company in the 2nd subform. The logic being that each Company is only allowed to have certain Raw Materials collected, so the tbl_company_material dictates which Company is associated to which Raw Material.
So I need the dropdown to be refreshed each time:
A new collection is added in the Collections subform.
When the Company in the Collections subform.
When the Company in the Collections subform is changed