Date on Report

[PJ]

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

 

[Al Campagna]

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."