Sam -

You will want to enter the same code on the BeforeUpdate event of the form,
or the AfterUpdate event of the DOB field so the error displays. I would
also include an Else clause to set the .visible to false for the cases where
the criteria is not met.

I don't see any code to turn the warning off if they have been warned
already, so you may want to include setting the Yes/No field to Yes whenever
you display the warning label.

--
Daryl S


"SamMexico via AccessMonster.com" wrote:

Hi John, thanks for your help - I followed your instructions : added a Yes/No
field to the table, put the code into the Current event and added the big
label control. I tested it using a new record with a data just over 2 years
ago but nothing seemed to happen - any ideas?

Thanks,

Sam

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/201004/1

.