Auto update date field

#1

In Access 2000, can anyone enlighten a beginner with how to make a
date field in a table auto update evertime another field is updated?
In this case I want to update a field called ynDues2004 (a
yes/field) and have a field dtDues2004 update with the current date
when this happens.
Any help would be greatly appreciated, I let this go too long .
Thanks
Mike

#2

web265 (AT) aol (DOT) com (Mike) wrote in message news:<1f1946ee.0407060722.43b60efe (AT) posting (DOT) google.com>...

Quote:

In Access 2000, can anyone enlighten a beginner with how to make a
date field in a table auto update evertime another field is updated?
In this case I want to update a field called ynDues2004 (a
yes/field) and have a field dtDues2004 update with the current date
when this happens.
Any help would be greatly appreciated, I let this go too long .
Thanks
Mike

Hello Mike,

Just add the following code into the After Update property of the
field ynDues2004:

dtDues2004.value = Date()

Regards,

Ray

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Auto update date field

comp.database.ms-access comp.database.ms-access

Auto update date field - 07-06-2004 , 10:22 AM

Re: Auto update date field - 07-08-2004 , 10:33 AM