I am creating an entry form for tracking mailings. When the mailing goes out the operator will enter the date of the mailing into a field on the form which corresponds to a table field called “DATEMAILED”. The next time there is something mailed, I need for the new date to be entered into “DATEMAILED” and the old date to be transferred to a field named “LASTDATEMAILED”. Is this possible?
P.S. I know nothing about macros if this is the way to go.