So here is the set up..
The way my form works right now , is teacher picks from drop down their name, then their location from the second drop down. Then the teacher enters name of a student in one "single-line" box, and the students email in another single line entry box. .. then they press submit.. Only to then repeat the process, each time re-picking their name (instructor drop down) , location (drop down), then entering student, name and email into single lines ...
So my thought was, could the selected values in the drop downs just stay selected for the user's session after pressing submit ?.
Rather than having them reset to pick them again and again ? This way all they are doing is entering teach name, and location once.. and then just entering student email and name, pressing submit, repeating the process , but now the teacher name, and location would be waiting...
Side note : The output of the data has to be in this format. One row with teacher name, location, student 1 name, student 1 email, another student means another row of same info, plus additional student info.. This data then gets exported to access 2003.