Current date on form upon editing...

[spalmateer]

Hello,
I have a customer information form that has a last updated field. Currently our data entry person has to manually update this field any time the form is changed but I would like to find a way to automate this so that upon editing any fields in the form (or subform), the field (last updated) automatically enters todays date. Thanks in advance for your help and insight!I'm sure that there is probably a very easy way to do this that I'm overlooking. Thanks

[This message has been edited by spalmateer (edited 12-10-2000).]

 

[Jack Cowley]

I could send you a demo but I think you will learn more from reading and implementing this article. You will need to make a minor change or two in the code to get it to do exactly what you want, but that should not be much of a problem....
http://support.microsoft.com/support/kb/a rticles/Q183/7/92.ASP?LN=EN-US&SD=gn&FR=0&qry=q183792&rnk=1&src=DHCS_MSPSS_gn_SRCH&SPR=ACC97

[This message has been edited by Jack Cowley (edited 12-10-2000).]

 

[spalmateer]

Hi Jack,
Thanks for the help. What is the advantage of doing it this way verses changing the form properties upon edit to run a macro that updates the date field to current date. I haven't tried this yet but is it still better to do it the way you mentioned. I was eventually going to do something with an audit trail to see who edited what information for security but I'm still in the early stages of design for this database. Thanks again for the help!

 

[Jack Cowley]

I guess it is a matter of choice. Since you have to do some code anyway why not do the whole nine yards first time out and then you are done. No need to go back and do it again later. Just my opinion and you should do what will work best for you.....

Good luck!