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

 

[orange]

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

You haven't mentioned the form you're working with, however, we'll give it a shot.

You could use the AfterUpdate event of the form's checkbox.

You could edit the current record and Update your Datefield(whatever it's called) to be the current date/time.

You may wish to look at Form controls, AfterUpdate event, and Date.

See this example site: http://www.blueclaw-db.com/access_event_programming/l