K
KM
I am trying to create a multi period budget forecast form
1 text column and 14 number data columns are require (forecast periods and
cost savings)
4 of these columns will have updatable fields to allow on the fly changes.
The data rows have 21 possible forecast lines that need to be presented for
which different formats apply - some are standard numbers others %
Sub totals are required between these data rows.
The issue is this results in more than 255 fields that I need to track.
ie 14 * 21 = 294
I tried using arrays. and the form works great. (code updates the form on
poiter changes)
But unable to print the data from the form....
I think this is because I need to have the form tied to a querry or table
for the data to be visible in the printed copy (not sure)
I have tried multiple sub forms and this works too, but it is very slow in
form updates.
So 2 questions:
How does one get data on a form NOT linked to a table or querry to show on a
hard copy print out?
What is best way to to design this type of form? Multiple sub forms, array
usage, something else....
1 text column and 14 number data columns are require (forecast periods and
cost savings)
4 of these columns will have updatable fields to allow on the fly changes.
The data rows have 21 possible forecast lines that need to be presented for
which different formats apply - some are standard numbers others %
Sub totals are required between these data rows.
The issue is this results in more than 255 fields that I need to track.
ie 14 * 21 = 294
I tried using arrays. and the form works great. (code updates the form on
poiter changes)
But unable to print the data from the form....
I think this is because I need to have the form tied to a querry or table
for the data to be visible in the printed copy (not sure)
I have tried multiple sub forms and this works too, but it is very slow in
form updates.
So 2 questions:
How does one get data on a form NOT linked to a table or querry to show on a
hard copy print out?
What is best way to to design this type of form? Multiple sub forms, array
usage, something else....