I have a continuous form in MS Access being fed by a query. It produces a total of around 45 records. For each row, I display a result from the query and then provide four input boxes to the user. At the bottom of the form there is a “Submit” button. When the user clicks the “Submit” button, I’d like to make a VB routine that will loop through each of the rows, manipulate the input in the four boxes, and run a query–that is, clicking “Submit” should run a total of 45 queries, with each query being based on the data input by the user on a single row.
Unfortunately, I can’t find or figure out how to access each individual row programmatically from within the form footer scope; if I try to retrieve data, force a button click event, or anything else, it only affects the data on the very first row.
Is there a different technique I should be using here?
