OK...this one is simple .... but not for me.
I am currently emailing reports to specific people by the selection of a combo box, PM, as well tracking what report and when the report was printed using code in the OnOpen event of the report.
i.e. if RN is selected in the combo box, PM, then Roberta Newton gets an email of the report and tTracker is updated.
tTracker currently has 3 fields, 1)What Report, 2) Date Printed, and 3)Time Printed.
My questions is, I want to add a field to tTracker named PM and have that field updated with the PM's initials that the report was sent to, in this case RN. How can I do this? One of the fields in the report is "PM" also.
Thanks in advance.