Nicole
Posts: 586
|
| Posted: 01/20/2005, 2:59 AM |
|
Hello,
To check was field value modified by user or not you need to compare current field value with a one stored in a table before update code is fired, e.g. in Before Update event.
To get the current field value use
form_name.field_name.value
to obtain a table’s value you need to execute custom query or call CCDLookUp() function:
Dim old_value
Old_value = CCDLookUp("field_name", "table_name", form_name.DataSource.Where, DBConnection_name)
Then compare both values with the help of VBScript StrComp function
if StrComp(old_value, form_name.field_name.value) <> 0 then
response.write "the value was modified <br>"
end if
Using this approach collect modified values and use them in send mail code.
_________________
Regards,
Nicole |
