Printing a form to change data?

[Chrisopia]

Basically, I need to amend data when I print a form the "date last printed" is updated.

I cant figure out where to begin or imagine how its done as I'm used to amending data 1 record at a time, but printing address labels for example include 3,000+ records which all need to be changed to update the date it was last printed.

What is this data manipulation method called? Or where do I begin?

Thanks in advance

 

[John Big Booty]

Form's are generally reserved for viewing/adding/editing data on screen, whilst it is more common to use reports to print that data for presentation purposes.

You could have a table which maintains the date a report/document was last printed, you could extract the date last printed by using the DLookup() function, it might look something like;

DLookup("LastPrint", "YourTableName", "DocumentType = " & Me.DocumentType)

Then as part of your print process you could use an update query to update that date to the current date using the Date() function, it might look something like;

UPDATE TBL_YourTableName SET TBL_YourTableName.LastPrint = Date()
WHERE (((TBL_YourTableName.DocumentType)=1));