Dear All
I need to pull the calculated values from approximately 10 forms into another form. This is a summary form that should have all the totals pulled from the other forms.
e.g. Form A has a textbox that reflects the sum of the amount. This is the total balance of form A.
Form B, Form C, etc. all have a total Balance.
Now, i need to pull all these totals into a summary form
Form A Total Balance: £x
Form B Total balance: £y, and so forth.
How and what is the best method to approach?
I have tried using Forms![Formname]![Total] to get the data. This necessitates the need to hide all these forms and I ended up with blank forms, etc.
Even so, the total sometimes appear and sometimes it does not. so it is very unstable.
i hope someone can help asap!
Thank you.
I need to pull the calculated values from approximately 10 forms into another form. This is a summary form that should have all the totals pulled from the other forms.
e.g. Form A has a textbox that reflects the sum of the amount. This is the total balance of form A.
Form B, Form C, etc. all have a total Balance.
Now, i need to pull all these totals into a summary form
Form A Total Balance: £x
Form B Total balance: £y, and so forth.
How and what is the best method to approach?
I have tried using Forms![Formname]![Total] to get the data. This necessitates the need to hide all these forms and I ended up with blank forms, etc.
Even so, the total sometimes appear and sometimes it does not. so it is very unstable.
i hope someone can help asap!
Thank you.