Message box when criteria is met

I have a table as a record source for a data entry form.  One of the fields in the table is OrderDate.  When the user enters a new record on the form and the new order date (today's date) is 5 years AFTER the last order date for that particular part number I want a popup message box to appear letting the user know that...

"Please review the order history for this part.  It was last produced (insert date last order date)”

How can I do this?  I know how to do a DMax for the order date but I don't know the syntax for 5 years prior to today's date.
SteveL13Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Anders Ebro (Microsoft MVP)Microsoft DeveloperCommented:
To get the date from 5 years ago you could use:
DateAdd("y",-5,Date())

Open in new window


Then it would read as:
If Dmax([your expression here])<DateAdd("y",-5,Date()) then

Open in new window

0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Gustav BrockCIOCommented:
It's not "y" but "yyyy" ...
1
Anders Ebro (Microsoft MVP)Microsoft DeveloperCommented:
Thank you Gustav. Your absolutely correct. Silly mistake on my part.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.