Fields created in a Form (not table or query)

[jayme27]

When you create any report, it prompts you to use the fields stored in a Table/Query.
What if you created fields you want to use in your Forms?
For example, in one of my Forms, I created a field that keeps a running date and one that uses an equation to tabulate another field. If I cannot store these particular fields in my Table/Query, how am I able to use them to display in my Report?

Thank you for anyone that can answer this question

 

[TonTon]

You can refer to them in your report by setting the ControlSource of a text box to:
=Forms![FormName]![ControlName]

FormName is the name of your form.

ControlName is the name of the control on that form.

Hope this helps
Tony