Prev: Object or class does not support set of events
Next: Date format in a combo box
From: SamMexico via AccessMonster.com on 16 Apr 2010 05:15
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/Forums.aspx/access-forms/201004/1

From: Daryl S on 16 Apr 2010 09:48
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/Forums.aspx/access-forms/201004/1
>
> .
>
First  |  Prev  | 
Pages: 1 2
Prev: Object or class does not support set of events
Next: Date format in a combo box