Par2: Manual control of autoincrement/autonumber keys 1998-05-18 -- Steve Parker This is particularly appropriate for a form not called by a browse.
Where TES:SysID is the field to be autonumbered:
WindowManager Method Executable Code Section
PrimeFields
()
If ~TES:SysID
Access:TestFile.PrimeRecord
Access:TestFile.PrimeAutoInc
End
You may wish to try the TryPrimeAutoInc method.
Strictly speaking, the test for the value in the field may not be necessary.
In the Cancel button's Accepted, Before Generated code embed:
Access:TestFile.CancelAutoInc
Printed October 24, 2026, 2:49 pm This article has been viewed/printed 36220 times. |