Automatically insert date when other field is true?
in [Forms]
|
From: KLP34 on 28 Jan 2010 11:33 Works like a charm! I am very grateful ... Thank You! "Mike Painter" wrote: > Stuart McCall wrote: > > "KLP34" <KLP34(a)discussions.microsoft.com> wrote in message > > news:A8FD9F11-7045-4FCB-BAAC-37D895ABC185(a)microsoft.com... > >> I have a date field and a yes/no field. Is it possible to have the > >> program insert the current date when the yes/no field is checked? > > > > Insert the following code into the checkbox's AfterUpdate event > > procedure: > > If Me.checkBox = True Then > Me.txtDate = Date() > else > Me.date = ... > ' NULL or a date far in the future are options. > End if > Without the "else" the date will remain even if you uncheck the other field. > > > . >
From: Mike Painter on 28 Jan 2010 12:50 Thanks should go to Stuart. KLP34 wrote: > Works like a charm! I am very grateful ... Thank You! > > "Mike Painter" wrote: > >> Stuart McCall wrote: >>> "KLP34" <KLP34(a)discussions.microsoft.com> wrote in message >>> news:A8FD9F11-7045-4FCB-BAAC-37D895ABC185(a)microsoft.com... >>>> I have a date field and a yes/no field. Is it possible to have the >>>> program insert the current date when the yes/no field is checked? >>> >>> Insert the following code into the checkbox's AfterUpdate event >>> procedure: >>> If Me.checkBox = True Then >> Me.txtDate = Date() >> else >> Me.date = ... >> ' NULL or a date far in the future are options. >> End if >> Without the "else" the date will remain even if you uncheck the >> other field. >> >> >> .
From: Stuart McCall on 28 Jan 2010 14:29 "Mike Painter" <md.painter(a)sbcglobal.net> wrote in message news:v7k8n.16712$Fe4.10825(a)newsfe21.iad... > Thanks should go to Stuart. Tell you what, you pat yourself on the back and so will I. :-)
|
Pages: 1 Prev: Latest date in a form Next: Alert user to check the filed when it is final |