Date on Report

  • Thread starter Thread starter PJ
  • Start date Start date
P

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
 
PJ,
In the event procedure...
Click to expand...
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."
 
Back
Top