Set Date field to today's date

  • Thread starter Thread starter ABC
  • Start date Start date
A

ABC

Hi all,
I have auto populate field for today date in my table. I
want this field to get update and change to the current
date whenever on field residing in the same table is
updated. I want only the one record to change it's date to
current for which the other field was update or change.

Any help would be appreciated...

thanks
ABC
 
It is a little confusing on what you are trying to state but it seems like
you want to be able to update a field with the current date each time a
record is saved.

One option would be to keep a hidden field on the form (text box) who's
control source is: =Now().

Each time you save, this information is saved.

HTH

--
Rob

FMS Professional Solutions Group
http://www.fmsinc.com/consulting

Software Tools for .NET, SQL Server, Visual Basic & Access
http://www.fmsinc.com

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 
Thanks for getting back. That was a really good
solution...but this happens for all the rows in that
table.. i would just like to make update for the single
row..

sorry for miss communication ,,,,
thanks in advance for you help
ABC
 
Back
Top