Auto update a date field when a checkbox is ticked

[Sharon Beresford]

Hi All
Does anyone know how I can automatically populate a data/time field when a check box is ticked? This needs to be at record level. thanks


Submitted via EggHeadCafe - Software Developer Portal of Choice
Get Identity Values of Multi-row insert by using OUTPUT Clause
http://www.eggheadcafe.com/tutorial...5-dd4f996da99f/get-identity-values-of-mu.aspx

 

[BruceM via AccessMonster.com]

If you mean when the check box receives a check (rather than when it is
cleared), in the check box After Update event:

If Me.CheckBoxName = True Then
Me.SomeField = Now()
End If

If you want the time/date to be updated whenever the check box value changes,
leave out the If and End If lines.

If you want the date only, use Date() rather than Now(). Actually, Date()
will store the time, but it will always be midnight. This could make a
difference in sorting under some circumstances.