Flag changes with date

[Sohaila Taravati]

Hello everybody,
This should be very easy for you. I am planning to send post cards to customers to notify them for their move. I made the post card and it works so far. I have a date field in my table for when every time there is a card that is printed would put today's date that this card was printed. I would like to know if there is a way that I can do this without using an update query, so everytime they print it autmatically puts today's date in the field.

I also have another field that that is automatically generates other dates based on changes in certain information. It puts the date that there was a change for a shipment and based on that date, I want to be able to reprint the cards if any change. I hope this makes sense. I would really appricaite any help I can get.
Thank you,

 

[Rich]

Why would you not want to use an update query, or the DoCmd.RunSQL

 

[Sohaila Taravati]

I want to make this as easy as possible for the user. When they click the button it just prints and does everything that I want in the background, with no questions to ask. I thought there are other ways of doing this without running an update query. I was thinking of putting some kind of code in the report so everytime it's printing would put today's date in the filed.

 

[Rich]

A stored Update query is the most efficient way, you can simply Set Warnings False when running the query, the problem with doing this is that the Report may not actually print, without user intervention you depend on the reliability of your printer/operating system.
Don't forget to set the warnings back to True