Auto update a date field when a checkbox is ticked


Ad

Advertisements

Joined
Dec 17, 2007
Messages
57
Reaction score
0
Sharon Beresford said:
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/tutorials/aspnet/03c8104d-7deb-425e-beb5-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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top