Data restriction by month

  • Thread starter eddy via AccessMonster.com
  • Start date
E

eddy via AccessMonster.com

Hi,

I just want to put some month age restriction to my database when user open
form. For example more than 3 month data, all field will be lock. All data
refers to field "InputDate". I tried with dateadd but it doesn't work.

Thank you
 
M

mscertified

Look at DATEDIFF function in Access help.
Put code in OnCurrent event to lock all fields when date meets your needs

-Dorian
 
Top