Passing function to report

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

Guest

I have a report that I want to pass the results of a function to. The
function (which captures the user's NT Logon ID, is written by Dev Ashish and
works Great!) is in a module and runs on an On Open event. The name of the
unbound control is passNTUser and has a value before it gets passed back to
the report. If I put anything as a control source, I get the dreaded #Error.
If I don't give it a control source it isn't populated by the results of the
function.

I've used this function on forms, but never for a report. What am I missing
here?

tia
 
The function should be in a public module. Set the control source to:
=fOSUserName()
 
Back
Top