How do I show last date form was modified?

M

MTKIDD62

I have a form that prints to a report and would like to show the date of the
current form (anytime a change is made to the form not the records) on the
report. How would I go about this?
 
S

Sergey Poberezovskiy

With a bit of code:

In Report_Load event you can change Caption property of
your dedicated Label to:
Application.CurrentDb.Containers("Forms").Documents
("Form1").LastUpdated
Just put your form's name instead of Form1.

Hope this helps.
 
L

Lynn Trapp

I'm not quite sure what you are after. What kind of change to the form do
you have in mind?
 
M

mtkidd62

I'm not sure about the Report_load event.

Sergey Poberezovskiy said:
With a bit of code:

In Report_Load event you can change Caption property of
your dedicated Label to:
Application.CurrentDb.Containers("Forms").Documents
("Form1").LastUpdated
Just put your form's name instead of Form1.

Hope this helps.
Click to expand...
 
B

Brendan Reynolds

Reports don't have a Load event, but I expect Sergey probably meant the Open
event.

--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com

The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.
 
S

Sergey Poberezovskiy

He most certainly did.
-----Original Message-----
Reports don't have a Load event, but I expect Sergey probably meant the Open
event.

--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com

The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E- mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e- mail, you'll find
a useable e-mail address at the URL above.





.
Click to expand...
 
Top