536 Form design: AutoAppend property
VERSIONS: All

SUBJECT: InsertRecord() and AutoAppend property

BY: MARC B. WEISS

If you have auto-append turned on in the datamodel, then inserting a new record by moving past the end of the table will not generate a dataInsertRecord action. There are two solutions:
  1. My preferred: set auto append OFF in all tables in the data model. Then you will have complete control when anyone inserts, and the user must insert deliberately. not by accident by moving down.
  2. If you must have the auto append on, an insert record action will take place as soon as you type in the first character. Until you put data in it a record created by moving past the end of the table will have a BlankRecord property of true

To index