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?

[Webinar] Streamline your web hosting managementRegister Today

x
 
mbizupConnect With a Mentor Commented:
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
All Courses

From novice to tech pro — start learning today.