Originally Posted by
ItsMe
The way I see it, your table for Batch Size should have three records in it, 100000, 400000, 1000000. Then you would have functions determine which size and how many to use by referencing the table.
It probably makes more sense to include those values in your VBA code as Enums. Then within the same Standard Module, you could create various functions that would compare the nos Demand to the available Batch Sizes. I am imagining a couple of private functions that support a single public function. Provide the Demand to the Public function and have the Public function use the helper methods to return an answer.
So, as the User interacts with a form, code behind the form can pass the Demand argument to the Public Function. When the public function returns an answer, code behind the form will manage the appropriate updates, appends, etc.