Update a field when a checkbox is clicked

[N. Graves]

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

[Larry Linson]

"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