Processing Multiple Forms

[mjjk91]

G'Day All,

Here is a problem i am having, and would be a massive help if anyone can help me resolve it. The Screenshow below will accompany my problem:



Basically the issue i am having is i have a set of 15 records in a table, each record identified by a unique primary key. Now, i have a query that runs while a record exists, and outputs a form containing the information for each record (as above). Now as it stands, if i want to modify a record, i need to modify the record i choose, press select, and then head back to the above screen and modify another record. What i would like to do is have it so that i can modify the output for every record, but then only have one submit button at the bottom of the screen, which will then change all of the records information, not just one at a time. Im not sure how i can do this, seeing as though i have multiple forms, with each containing information based on a record with a unique key id. Anyone got any ideas?

Thanks everyone

Mick Koch
http://www.joeysfc.com
_________________