Fill in a date when an action has taken place

[Vol]

I have several different types of confirmation letters that print for clients. They are all linked to a specific "LetterCode".

At the time each letter is printed, I would like the action to auto fill the "LettersSent" field, with both the letter code and the date/time.

Any help would be wonderful, wonderful, wonderful...
Thanks
Vol [sig][/sig]

 

[Lightning]

How you do this will depend on how you run your reports.

If you run the report from code on a command button on the form, simply add some code to the bottom of your code to set the letter sent field with a concatenation of the letter code and the current date

[LetterSent] = [Lettercode] & " " & Now()

If your running the report in some other way, you could put similar code into the report's Deactivate property. You will need to open the form first, and then move to the specific record.


Hope this helps. X-)

Lightning

[sig][/sig]