Set Date field to today's date

[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

 

[RobFMS]

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

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

 

[Guest]

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

 

[RobFMS]

Then you will need to apply a WHERE condition to the query.

An example would be:

Select FirstName, LastName, City, State
From tblCustomers
Where State='VA'

--
Rob

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

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

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-