I am creating a data entry form for tracking mailings. When the mailing goes out the operator will enter the date of the mailing into a column in the table named "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 column named "LASTDATEMAILED". Is this possible?

Assuming DATEMAILED and LASTDATEMAILED are on the same form then this code in the After Update event of the DATEMAILED field should do the trick for you:

Me.LASTDATEMAILED = Me.DATEMAILED.OldValue

I entered the line into the correct properties field and Access is telling me that the macro that I have called for does not exist. Is this solution a macro? If so, I know nothing about creating an Access macro because I never have had an occasion to do so. Could you please help? Thank you.