You need to open the form in design-view. Go into the form's properties box
and find the "update" event. double-click in that field or select "event
procedure" from the drop down, then click the elipse to the right (...).
Update the code window as outlined in my earlier post.
Hope that helps.
Rick B
"Tony" <(E-Mail Removed)> wrote in message
news:972D81D9-4E81-44BB-BAC3-(E-Mail Removed)...
> I haven't done any coding in Access before. Where do I insert that code?
> And what does "Me" standfor in Me.LastUpdate?
>
> We have a responder table that holds most of the info and we wanted this
> lastUpdated to change when we touch any of the others...will that be the
case?
>
> Thanks Rick!
> Tony
>
> "Rick B" wrote:
>
> > Putting the code in the Before Update will cause it to update when you
make
> > a change to the record, but not if you simply view the record.
> >
> >
> > Private Sub Form_BeforeUpdate(Cancel As Integer)
> > Me.LastUpdate = Date()
> > End Sub
> >
> >
> >
> >
> > Rick B
> >
> >
> >
> >
> > "Tony" <(E-Mail Removed)> wrote in message
> > news:F403D033-C7D7-4E48-BCDA-(E-Mail Removed)...
> > > Lynn -
> > >
> > > I have a field called lastUpdated and it is a manual field that we
change
> > > whenever we get a new email/phone/address/add a course, etc in a
training
> > > table.
> > >
> > > What coding do I use for that field? I tried it on the berfore and
also
> > on
> > > the after update field and still didn't have any luck.
> > >
> > > I do this on the form...for the field lastUpdated...and put that event
in
> > > there, right?
> > >
> > > Thanks!!!
> > > Tony
> > >
> > > "Lynn Trapp" wrote:
> > >
> > > > Put the following code in the BeforeUpdate event of your data entry
> > form.
> > > >
> > > > Me.txtYourDateField = Date()
> > > >
> > > > --
> > > > Lynn Trapp
> > > > MS Access MVP
> > > > www.ltcomputerdesigns.com
> > > > Access Security: www.ltcomputerdesigns.com/Security.htm
> > > >
> > > >
> > > > "Ngina 28" <Ngina (E-Mail Removed)> wrote in message
> > > > news:863A3C9B-8557-4238-8012-(E-Mail Removed)...
> > > > > How can I make the date field change that I set up automatically
> > change
> > > > when
> > > > > I make changing in my other fields... etc. If I change a persons
name
> > in
> > > > the
> > > > > name field, I want my date field to reflect and change when I made
the
> > > > > change.
> > > >
> > > >
> > > >
> >
> >
> >
Similar Threads
