Simple question from a novice..
I have multiple forms (each with a slightly different format but shouldn't affect the code), each form on a click of a command button performs the same task in calculating a bunch of figures which are put into variables then updated back on to the form into text fields.
The code works fine (albeit a little messy and in need of a big clean-up) but I don't want to have duplicate code in each form creating the huge danger of having differences across forms.
What's the best way to go about this?
Also have an array variable, say 5 rows and 7 columns, some forms will have more columns - can you set the column count to be dynamic per form or can you set it to be the greatest value and have empty spaces for some?
I have multiple forms (each with a slightly different format but shouldn't affect the code), each form on a click of a command button performs the same task in calculating a bunch of figures which are put into variables then updated back on to the form into text fields.
The code works fine (albeit a little messy and in need of a big clean-up) but I don't want to have duplicate code in each form creating the huge danger of having differences across forms.
What's the best way to go about this?
Also have an array variable, say 5 rows and 7 columns, some forms will have more columns - can you set the column count to be dynamic per form or can you set it to be the greatest value and have empty spaces for some?
