Approach User Support homepage Approach User Support
Answers to Frequently Asked Questions about Lotus Approach
Examples LotusScripts
Example databases
Links to other Lotus Approach support services

[Return to contents]

Example LotusScript: Script Launch at Record Change Event

Last updated: before December, 1998

 'Written by Jerry Sikes, 1997
   '(C) Copyright 1997 by Jerry Sikes
   '
   'Permission is granted to freely copy this script in electronic form,
   'or to print for personal use. It may be use in any Approach database,
   'but may not be distributed for profit either by itself or as part of
   'a collection or database.
   '
   'Disclaimer: This script is provided as is without any express or implied
   'warranties. The author assumes no responsibility for errors or omissions,
   'or for damages resulting from the use of the information contained herein

I've been stumbling along with scripting and stumped on how to have a script
launch as I browse through each record. Finally I stumbled across how. The
event is RecordChange and available only as a DocWindow event.
In the script window, under objects, the objects are divided into three
sections. Globals, your application and Approach itself. The last object
available as you drill down your application objects is DocWindow. Care must
be used with attached script. The script will run regardless of the form your
on. If - Then - Else statements must be used to control action for a singular
form. I have had success with the following:
If currentview.name="My Form Name" Then
'add true action here
Else
'add false action here. False action is optional.
End If
The script executes with each change in record number, regardless of the
method of change.

[Return to contents]

© Copyright, JohnBrown, Trademarks, Disclaimer, Acknowledgements.