InfoPath Dev

Is it possible to have a submit button that sends the form to a network share and prints out the form onto a networked printer?  I'd like to only have 1 button that does both functions.

I have a form with a repeating table, which is pulling data from a SharePoint list.  The table has 5 columns, the first 4 columns are read only, populated from the SharePoint list, the last column is a text input field.  People input a number into the text field for some of the rows.  Is there a way to hide all ...

Thanks for your reply. So I was able to get the three columns to change based on what I choose from the first column drop down list, however, if I change the drop down list to something else the other 3 columns don't change ,they don't do anything.  How do I make it update the other columns again?

In my form I have a table with 4 columns, the column headers are: Code, Item, Unit, Cap.  I have a SharePoint list which contains all the data with the same 4 columns.  I would like to be able to have the Code field as a drop down list in my form that looks up all Codes in the SharePoint list and once I choose a code, the other ...