Web Development

Ask something
Question Locked

MS Access 2003 - Continuous Forms

0 helpful
2 replies

by kyle.woodlock

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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?

2 replies

by kyle.woodlock

Okay, I figured out at least one way of doing this, by manually navigating through the records using DoCmd. I'll leave this up here in case there's a cleaner or more graceful way, though.

This discussion is closed to new replies.