automatically recording date Patrick 29.09.2006 17:00:02 In my form, I want to be able to have the date automatically entered for a record, after a change or modification is made to an existing record.

Re: automatically recording date "Douglas J. Steele" <NOSPAM_djsteele[ at ]NOSPAM_canada.com> 29.09.2006 17:03:30 Add a LastModified Date/Time field to your table. In your form's BeforeUpdate event, add code to set that field to Now(). -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) "Patrick" <Patrick[ at ]discussions.microsoft.com> wrote in message news:9D8A40B5-664E-4345-A604-194C7C8068E1[ at ]microsoft.com... [Quoted Text] > In my form, I want to be able to have the date automatically entered for a > record, after a change or modification is made to an existing record.

RE: automatically recording date Klatuu 29.09.2006 17:05:01 Use the form's Current event: Me.txtMyDateField = Date() "Patrick" wrote: [Quoted Text] > In my form, I want to be able to have the date automatically entered for a > record, after a change or modification is made to an existing record.

Re: automatically recording date "Douglas J. Steele" <NOSPAM_djsteele[ at ]NOSPAM_canada.com> 29.09.2006 17:11:15 I don't think that's really what you want. That'll update the date every time you access it, even if no change was made. -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) "Klatuu" <Klatuu[ at ]discussions.microsoft.com> wrote in message news:01319125-CC76-4CD0-B927-58B8420AC863[ at ]microsoft.com... [Quoted Text] > Use the form's Current event: > Me.txtMyDateField = Date() > > > "Patrick" wrote: > >> In my form, I want to be able to have the date automatically entered for >> a >> record, after a change or modification is made to an existing record.

Re: automatically recording date "Ron2006" <ronnemec[ at ]hotmail.com> 29.09.2006 18:51:12 Try the OnDirty Event That says a change was made somewhere. Ron

Re: automatically recording date "Douglas J. Steele" <NOSPAM_djsteele[ at ]NOSPAM_canada.com> 29.09.2006 22:01:33 I still think BeforeUpdate is a more appropriate event. -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no private e-mails, please) "Ron2006" <ronnemec[ at ]hotmail.com> wrote in message news:1159555872.533876.304900[ at ]k70g2000cwa.googlegroups.com... [Quoted Text] > Try the OnDirty Event > > > That says a change was made somewhere. > > Ron >