I am sure this is a no-brainer, but I am stuck. How do you pass the value of a variable (set in vba code) to a report?
In the page footer of my report I need to display the beginning time( of a command button click), and the end time (which is when the report is generated). The end time I can do. The dtBegTime variable is set as soon as the click event is triggered for the command button. What I am having trouble with is getting that time to display in a text box in my page footer. How do I call the value in the dtBegTime variable?
Start Free Trial