Enter data on update

  • Thread starter Thread starter NHiorns
  • Start date Start date
N

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)
 
DBEngine(0)(0).Execute "UPDATE [Labels] SET [Reply] = Now where PKField = "
& Me!PKField , dbFailOnError
 
or ... have the BeforeUpdate event set a hidden box (bound to field Reply)
to Now ()



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



NHiorns said:
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)
Click to expand...
Click to expand...
 
Back
Top