How to pass a value from a Public function to a report?

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

Guest

I have a public function, that I have tested using a MsgBox. It is
calculating the correct value. How to I show this value on a report?

There are two posts from other members I have tried to apply, but I am doing
something wrong. The 1st post is dated 10/19/04 with an Answer from Diane H.
titled Passing Function to report. The 2nd is dated 7/12/05 with an answer
from Dan S. titled Global Variables.

Any help would be great!
Charles
 
Return the value with the function
e.g
Function GetValue()
GetValue="The value"
End Function
============================================
In the ControlSource Property of any field in the Report write
=GetValue() ' Your function name
============================================
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calling a public function from within a report? 2
Passing values between reports 1
Passing values to subreports 1
Problem passing SQL string to Record Source property of a Report 3
How to pass parameters to a report 2
pass query parameter value to report 8
Help defining a public variable 1
Pass parameter value to sub report query 3

Back
Top