Post Date when data has changed

  • Thread starter Thread starter Diane
  • Start date Start date
D

Diane

I have a form with a datasheet with several fields. When
the user changes the QTY field, I want the Posted field
[date/time] to automatically be updated with the current
date/time.

How can I do that?

Thanks!
 
Diane,
Use the AfterUpdate event of your Qty field and run this code...
Me.[YourDateFieldName] = Date
This assumes that [YourDateFieldName] is a bound field, not a calculated
field.
Whenever Qty is changed, [YourDateFieldName] will be updated.
 
Al,
Perfect! Thanks!
-----Original Message-----
Diane,
Use the AfterUpdate event of your Qty field and run this code...
Me.[YourDateFieldName] = Date
This assumes that [YourDateFieldName] is a bound field, not a calculated
field.
Whenever Qty is changed, [YourDateFieldName] will be updated.
--
HTH...
Al Campagna
Candia Computer Consulting
Candia, NH

I have a form with a datasheet with several fields. When
the user changes the QTY field, I want the Posted field
[date/time] to automatically be updated with the current
date/time.

How can I do that?

Thanks!
Click to expand...


.
Click to expand...
 
Back
Top