An easy way to do it is to put 2 computed columns on the table, one with a date = .#date the other w/ time = .#time. This will update anytime the row is changed.
Troy >===== Original Message From [EMAIL PROTECTED] ===== >I need to place a DateTime stamp in a column when a row has been updated. > >Seems simple enough until you consider the following: > >Lets say the user accesses a Customer/Transaction form >(with the transactions being defined as a region) > >Initially, the focus is on the transactions. >If they click back to the top (Customer Side) and make a change >how can I detect a change to that specific table and update the >DateTime stamp? > >I've experimented with the following technics without success: > >- Triggers (too constrictive in forms with regions) >- Variables in Form (get evaluated regardless of change to data) >- Using an EEP on Entry/Exit to table <or> after Leaving Section > (Form_Dirty_Flag detects changes made to ANY table) > >Recommendations Anyone? > >TIA > >- Rob Vincent Troy Sosamon Denver Co [EMAIL PROTECTED] ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
