How to get Globals in a report

[datavisions]

I have a report that produces a letter using the results of a query. I have some globals that contain the current user name that I would like to use for the signature line. Is there an easy way to do this?

 

[thornmastr]

Design as function that will pass the value to a query then call it from within your query, Robert Berman
Data Base consultant
Vulcan Software Services
thornmastr@yahoo.com

 

[FancyPrairie]

You can also set the signature value (assume text box on the report) in the OnFormat property of the Detail section.

For example,

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)

txtSignature = CurrentUser

End Sub

 

[datavisions]

Thank you both for your help!