Getting a form Field Onto A Report

See attached.
Click MainMenu
Click Show All Customers
Click Top left option button (beside "B Murphy")
Note the green field with a value of 576.00.
Click "Print Job Sheet" at the bottom of the screen.
Observe the report rptJObSheet.

QUESTION: How do I get the "green value" of 576 onto this report.


I tried a few things but failed.   (e.g. Forms!frmCustomers .....??)
Key5.zip
Patrick O'DeaAsked:
Who is Participating?
 
mbizupCommented:
This will do it:

=[Forms]![frmCustomers]![GrandTotal]

frmCustomers needs to be open when the report is opened.
0
 
Patrick O'DeaAuthor Commented:
Thanks, Perfect!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.