How do I show last date form was modified?

[Guest]

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?

 

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

 

[Lynn Trapp]

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

 

[Guest]

Design changes such as adding or removing controls.

 

[Guest]

I'm not sure about the Report_load event.

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.

 

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

 

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





.

 

[Guest]

It worked great, thanks.

He most certainly did.