Data from a function in Report Header

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

Guest

Hello all ...

I have a function call which gets the full name of the user that is logged
into and running this program. It works fine in the forms. I would like to
use this info in the Page Header of a report (which is a simple internal
memo) along with the data from the database matching the criteria. The name
and department info (from the dadabase) works fine ... but I can not get the
name of the user to work for anything.

Any ideas?

Thanks for the help ... A G A I N
 
Hi Jerry

You can create a text box in the report header, in the text box control
source write

=FunctionName()
 
Ofer,

thanks when when I try - when the report opens an input box comes up asking
for the data.

the name of the call is fGetFullNameOfLoggedUser which works in all of the
forms and is available in the immediate window in VBA ... in fact is seems
that it is available everywhere but where I want it. :(

H E L P

Thanks again
 
Is the function fGetFullNameOfLoggedUser need to be in a module or did you
specify it in each form?
It need to be in module.

Can you post the function?
And what did you write in the control source of the text box?
 
Ofer,

You are right it works great ---- I'm not sure what I did wrong the first
time.

Thanks
 
Back
Top