[Return to contents]
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.