I am creating a form that needs to update different inventory items based on the formula used in creating our product. There are over a hundred formulas involved.

I anticipate that I would need to create a Formula form which would specify the inventory items used to create the formula. When the user fills in the formula value on the inventory utilization form, the corresponding formula record would be selected with the appropriate inventory items.

The question: how do I programmatically load the subform after entering the formula value?

When we build a product, we need to relieve inventory of the components of that  product. The components are listed in the formula record with quantities for the individual required components.

The plan is to create a usage form that will prompt the user for the formula used to create the product and the quantities of that product we created. We would also prompt for the date the product was created and the Lot ID of the new products.

So when we enter the formula ID into the form, we need the associated components to be listed on the form, presumably on a subform but not necessarily, so we can indicate quantities and lot numbers for each of the components, then adjust the inventory accordingly.

we would need to enter the quantity and the lot ID for each component. In the course of building the product we often use more than one lot ID of an individual component. In that case we would need to enter the quantity used of the first lot ID and its associated Lot ID, then the quantity used of the second lot and its lot ID.