Record printed pages 'as printed' with date in Invoice Table

[smorgan]

Hi


I'm developing a small access 2007 database for a friend who's not very computer literate!

I have arranged for a list of invoices to be printed, and would like to record the date of printing in the 'Invoice' Table

Can this be done, and if yes - how?

I look forward to a reply

Many thanks

Smorgan

[JoeM]

One way would to create a Form with a Print button that they click to print the invoices. Have the VBA code behind the print button not only print the invoices, but also run an Update Query to update your "printed by" date field in the underlying table to the current date.

[smorgan]

Many thanks for your feedback - I'll give it a try!