The provider/vendor chosed at top of form can have multiple entries for a given batch. When the parent ssn in the subform is filled in, a query runs to find all (unique) children found in tblWarrentHistory matching that ssn. That part works fine on the first subform record and populates the dropdown for child first and last name. The problem is when a new record for the same provider but different parent ssn is being entered. An error message saying the table (the query creates a temporary table to populate the dropdowns) is already open so it can't run a fresh query. I have tried closing the table and deleting the table but this doesn't work because the first form is still there and is using the table. Any help would be appreciated. Please let me know and I can email a dummy db with the problem form. It's just a tiny bit too large to upload on this forum.
Last edited:
