By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,426 Members | 3,338 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,426 IT Pros & Developers. It's quick & easy.

Update a field when a checkbox is clicked

P: n/a
Hello

I'm getting stumped and this is probably Access 101 but here goes.

I have a list of To_do's When I click on a checkbox "Complete" I want
automation to update a field called "Completed Date" to be updated
with the current date.

Please share with me the best way to do this. I have tried to do this
in VBA but I have not been able to correctly use the table and field
names to give it a value.

Thanks

Norris

x-- 100 Proof News - http://www.100ProofNews.com
x-- 3,500+ Binary NewsGroups, and over 90,000 other groups
x-- Access to over 800 Gigs/Day - $8.95/Month
x-- UNLIMITED DOWNLOAD

Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
"N. Graves" wrote
I have a list of To_do's When I click
on a checkbox "Complete" I want
automation to update a field called
"Completed Date" to be updated
with the current date.


I will assume your "list of To-do's" is, in fact, on a Form and that's where
the Checkbox is located. Put another TextBox on the Form, call it
txtCompletedDate, with a ControlSource of "Completed Date" and set its
Visible property to No. In the AfterUpdate event of the "Complete" checkbox,

Me!txtCompletedDate = Date() 'for Date only

or

Me!txtCompletedDate = Now() 'for both Date and Time

Larry Linson
Microsoft Access MVP
Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.