msgbox when product is expired

Jennacat

Registered User.
Local time
Today, 14:38
Joined
Mar 19, 2008
Messages
58
Quick question:

I would like a message box to appear when the user clicks on a product in the list box that's more than 3 years old. I would also like the the log-in date txtbox to be highlighted if it's more than 3 years old. I know I have to do this in code, but I can't figure out how to do the date thing. The log-in date is at text box and stored in short date format.
I know the coding is something like If me.logindate = ....... but I don't know the rest. Thanks for your help!
 
Try

If Me.LoginDate < DateAdd("yyyy", -3, Date()) Then
 
Thanks! It works great. I knew it was something simple like that. :D
 

Users who are viewing this thread

Back
Top Bottom