Date on Report

I have a command button in a form that refresh information in that form.

In the event procedure I have the following:
DoCmd.DoMenuItem acFormBar, acRecordsMenu, 5, , acMenuVer70

Is there a way once I hit the refresh button it will place that current date
of the last time I hit that refresh button in a current report when I print
it.

Thanks in advance

PJ,
In the event procedure...
What event?

Since you didn't indicate the date field name, or where it's located,
I'll use
DOLE (date of last edit), and assume a Date/Time field on your main form.

Just add this line to your code
DoCmd.DoMenuItem acFormBar, acRecordsMenu, 5, , acMenuVer70
DOLE = Now
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

"PJ" wrote in message
...
I have a command button in a form that refresh information in that form.

In the event procedure I have the following:
DoCmd.DoMenuItem acFormBar, acRecordsMenu, 5, , acMenuVer70

Is there a way once I hit the refresh button it will place that current
date
of the last time I hit that refresh button in a current report when I
print
it.

Thanks in advance