Is there a way for a 'date stamp' on a report?

[maacky99]

I have a report that is generated by my tech's entering info in a form. What I want is for the date to be automatically entered the day that form is completed and then stored that way. Currently, the report is just set up with the =Date() function, so I get the current date everytime I re-print an old report.

Any thoughts?

 

[IgorB]

You probably need another field with Date/Time data type which stored Time.
Use Time() built-in function as Control Source.

 

[Pat Hartman]

You need to add a date column to the table that the form is based on. Then add the following line of code to the form's BeforeUpdate event.

Me.LastUpdateDt = Now()

Then add LastUpdateDt to your report's recordsource query so you can print it.