How do I automatically update a date field upon data entered into another field?

BlackFireNova

This concerns an Access 2002 (XP) database. There are two fields,
"Notes" (Memo Field) and "Notes Update" on a form (among others)
which I am concerned with here.

Problem: I need to be able to tell when people have added notes to a
record. (this database contains 6000+ records)

I want to set it up so that "Notes Update" is updated to the current
date whenever someone actually enters data into, or modifies data in,
the "Notes" field (but NOT when just browsing the information in the
field).


How I tried to solve the problem:

I added a field called "Notes Update" in a date format to the table.

I wrote a macro and put it into the "After Update" field of the
"Notes" Field on the form. The macro simply jumped to the "Notes
Update" field.

I put =Date() in the "On enter" property of the "Notes Update" field
on the form.

My hope was that an entry in the "Notes" field would trigger a jump to
the "Notes Update" field, which would then cause Date() to put that
day's date into the field.

I also removed the tab stop from the "Notes Update" field to prevent
anyone tabbing to the field and changing the date that way.

Unfortunately it didn't work.

Can anyone suggest the best way to get this to happen?

Nov 12 '05 #1

Larry Linson

Create a Text Box bound to your last-updated-on field, set the value to
either Date() or Now() as you prefer in the BeforeUpdate event for the
record. The event won't fire unless the record is being saved. Seems too
simple -- maybe I missed something?

Larry Linson
Microsoft Access MVP

"BlackFireNova" <BFN_E-Subscriptions@myrealbox.com> wrote in message
news:8d486bed.0310132026.671bf81d@posting.google.c om...[color=blue]
> This concerns an Access 2002 (XP) database. There are two fields,
> "Notes" (Memo Field) and "Notes Update" on a form (among others)
> which I am concerned with here.
>
> Problem: I need to be able to tell when people have added notes to a
> record. (this database contains 6000+ records)
>
> I want to set it up so that "Notes Update" is updated to the current
> date whenever someone actually enters data into, or modifies data in,
> the "Notes" field (but NOT when just browsing the information in the
> field).
>
>
> How I tried to solve the problem:
>
> I added a field called "Notes Update" in a date format to the table.
>
> I wrote a macro and put it into the "After Update" field of the
> "Notes" Field on the form. The macro simply jumped to the "Notes
> Update" field.
>
> I put =Date() in the "On enter" property of the "Notes Update" field
> on the form.
>
> My hope was that an entry in the "Notes" field would trigger a jump to
> the "Notes Update" field, which would then cause Date() to put that
> day's date into the field.
>
> I also removed the tab stop from the "Notes Update" field to prevent
> anyone tabbing to the field and changing the date that way.
>
> Unfortunately it didn't work.
>
> Can anyone suggest the best way to get this to happen?[/color]

Nov 12 '05 #2

BlackFireNova

Larry:

I understand what you are saying about the text box, however I want
that date to be placed into the table, so a record of the updated date
is maintained. How do I get the date, once placed into the text box,
into the field in the table?

BFN

Nov 12 '05 #3

Tom van Stiphout

On 14 Oct 2003 20:45:47 -0700, BFN_E-Subscriptions@myrealbox.com
(BlackFireNova) wrote:

Presumably the field would be bound to the corresponding field in the
table.

-Tom.

[color=blue]
>Larry:
>
>I understand what you are saying about the text box, however I want
>that date to be placed into the table, so a record of the updated date
>is maintained. How do I get the date, once placed into the text box,
>into the field in the table?
>
>BFN[/color]

Nov 12 '05 #4