Hello, I am working on a spreadsheet type scheduler and have a few questions that I need help with. The first is how to pass a value. Lets say I have a form named Jobs. In jobs is a field called job code. Now I have created a button that allows me to create a sub form for each row that will allow the user to add more information about the job. This one will be called sub job. Now I want to make it so that when a user goes to enter in information into the sub job form, the job code box will be populated with the job code from the previous sheet. It also has to be the one from the row you pressed the button in.
The second part to my question is sums. I know how to sum a column and have it put the sum at the bottom of the rows but can I pass that value? If not is there some way to add a column together in one form and have it be subtracted from another form. This needs to be changed though everytime I add a new row to the old form?