Updating record..

[nagasrikanth]

Hi,

Here i was stucked with a new problem..

I have a table in which users modify data in a field .
upto now there wasn't any problem with this.but now i have a requirement like
when ever they update data in that field,then i have to update the time stamp in another field of same table..

hope u guys got my problem..one more thing is ..users will open the table directly and update data in the table it self..they wont use any form to open the table or to update the table.
so i also supposed not to use any forms...

is it possible to do like so..(like updating a field when another field was updated)

thanx & regards
anu..

[Dnereb]

as far as I know impossible in access. (MS SQL it is)
there is no event triggered if someone is altering data directly in a table.

You should consider not allowing users direct access to tables and query's anyways.
It's far safer to let them use forms.
not in the least to prevent data to be entered multiple times.... and other data validation like is it a valid date, is an order send date not a sunday etc...
etc...