Looking at the form more as a whole, here's how it will function.
Users will work with two main sections in the form: a Query section for typing in data so that they can query the database, and a Data Entry section, in which data is returned based on the query. Users would also type in new records in the Data Entry section.
As shown in the animation: In the Query section, the user types a name in the Company Name box. Then he or she clicks the Run Query button.
As a result, in the Data Entry part of the form, all data for the supplier appears in the Suppliers section. Data for all of the supplier's products appears in the Products section, or sections if there are multiple products.
This is where the form user would edit any of that data, if desired, and then submit the changes back to the database using the Submit button, which appears on the Standard toolbar.
The New Record button clears the values in the Data Entry part of the form, allowing the user to type a new supplier and its products.