Enter data on update

[NHiorns]

I have a form that is set to Continuous Sheets and Form
only. I have a text box for Miscellaneous information and
would like to on Update on this information that it put
date/time into another field.

I have thought of using the following...

DBEngine(0)(0).Execute "UPDATE [Labels] SET [Reply] =
Now;", dbFailOnError

However, as you would expect, once the update is done to
the [Notes] field it puts a date/time entry into every
[Reply] field for every customer, and not just the one
that has been amended.

How can I change so that the [Reply] field for only that
single customer is updated? (Access 2000)

 

[JohnFol]

DBEngine(0)(0).Execute "UPDATE [Labels] SET [Reply] = Now where PKField = "
& Me!PKField , dbFailOnError

 

[JohnFol]

or ... have the BeforeUpdate event set a hidden box (bound to field Reply)
to Now ()

DBEngine(0)(0).Execute "UPDATE [Labels] SET [Reply] = Now where PKField = "
& Me!PKField , dbFailOnError

I have a form that is set to Continuous Sheets and Form
only. I have a text box for Miscellaneous information and
would like to on Update on this information that it put
date/time into another field.

I have thought of using the following...

DBEngine(0)(0).Execute "UPDATE [Labels] SET [Reply] =
Now;", dbFailOnError

However, as you would expect, once the update is done to
the [Notes] field it puts a date/time entry into every
[Reply] field for every customer, and not just the one
that has been amended.

How can I change so that the [Reply] field for only that
single customer is updated? (Access 2000)