Re "to submit the form, add a submit button and click it" Sorry I misunderstood.
When creating the second recordset as suggested below
"set the recordset to filter by the selection made so that the count is for the selected product."
I cannot see how to do this in the second recordset from the filters allowed in the wizard.
I attached a pic to show my meaning.