Check Field Change

CodeCharge Studio

Visual Web Reporting

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

YesSoftware Forums -> CodeCharge Studio -> ASP

Check Field Change

Author

Message

Andrew

Posted: 04/12/2004, 2:24 PM

I want to send an email to someone if a particular field in a record form is changed and updated

At the top of the asp page I:

Dim OldStatID

in the before show record event I:

OldStatID=Projects.StatusID.Value (control in record)

In the before Update I:

If OldStatID <> Projects.StatusID.Value then

Andrew

Posted: 04/12/2004, 2:27 PM

OOPS...please see next forum entry...sorry

Andrew

Posted: 04/12/2004, 2:36 PM

http://forums.codecharge.com/posts.php?post_id=45617

These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

MS Access to Web

Convert MS Access to Web.
Join thousands of Web developers who build Web applications with minimal coding.
CodeCharge.com

Home | Search | Members | Register | Login