InfoPath Dev

 I have a infopath form the has 8 drop-down controls. The values are identical in each controlss. How can I copy the values in field 1 into the other fields?  I have the infopath form linked to a database. I created the fields first in Access and then created the infopath form from the db.    Another way of asking maybe ...

 I have a simple form in which students are typing in email addresses and then submitting them through a submit button. I first set up Access with the fields I needed and then used those to create the form in Infopath.  When I click on the submit button I get the message "InfoPath cannot submit form. The form does not contain any ...

I am new to Infopath and have a simple question. I have a form with 4 fields that students will fill out. I want to put a submit button and have the data entered by the students to go directly into an Excel file. How do I do that?