Fields created in a Form (not table or query) (1 Viewer)

jayme27

Registered User.
Local time
Today, 11:20
Joined
Nov 24, 1999
Messages
34
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

New member
Local time
Today, 11:20
Joined
Nov 2, 1999
Messages
9
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
 

Users who are viewing this thread

Top Bottom