Passing parameters on report

[jepoysaipan]

Hi,

Can someone help me on this one, I was trying to print the current user logged on my application; I tried to reference an unbound txtbox via an open form but no luck, also tried to set its value on the "on Activate" event but still can't get it.

Hope somebody can help.

Thanks.

 

[DCrake]

Simple Software Solutions

Hi

Create a public variable that holds the users login name, say pvMyLoginName

Create a function as follows

Function WhoAmI() As String

WhoAmI = pvMyLoginName

End Function

Next on your report in the section you want the users name to appear create a TextBox and on the recordsouce property enter =WhoAmI()

This should then work

Code Master: