Display a control on a switchboard that is linked to a separate re

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi all,

I'm hoping you can help. I have a database that when opened, displays a
switchboard form. On this form, I would like to incorporate a calculated
field that displays what is called 'Cure Rates'. Now, I have already done
this calculation on a separate report within the same database. The name of
this existing control is 'curerate'. Since it already exists on a report, is
it possible to display the results of that calculated control on the
switchboard? If so, how can I do this?

Thank you for any help you can provide.
 
Hi all,

I'm hoping you can help. I have a database that when opened, displays a
switchboard form. On this form, I would like to incorporate a calculated
field that displays what is called 'Cure Rates'. Now, I have already done
this calculation on a separate report within the same database. The name of
this existing control is 'curerate'. Since it already exists on a report, is
it possible to display the results of that calculated control on the
switchboard? If so, how can I do this?

Thank you for any help you can provide.
Click to expand...

Is the report going to be open when the switchboard is open?
If so, as control source of an unbound control on the switchboard:
=reports!ReportName![ControlOnReportName]

If the report is not open, then no it's not possible, as a report has
no data until and unless it is open.
Why not use a query to compute the same value as you do in the report.
Then you can use a DLookUp() to find that value"
=DLookUp("ColumnName","QueryName")
 
Back
Top