Data Control Constants

Error Event Constants

Constant Value Description
vbDataErrContinue 0 Continue
vbDataErrDisplay 1 (Default) Display the error message

Validate Event Action Constants

Constant Value Description
vbDataActionCancel 0 Cancel the operation when the Sub exits
vbDataActionMoveFirst 1 MoveFirst method
vbDataActionMovePrevious 2 MovePrevious method
vbDataActionMoveNext 3 MoveNext method
vbDataActionMoveLast 4 MoveLast method
vbDataActionAddNew 5 AddNew method
vbDataActionUpdate 6 Update operation (not UpdateRecord)
vbDataActionDelete 7 Delete method
vbDataActionFind 8 Find method
vbDataActionBookmark 9 The Bookmark property is set
vbDataActionClose 10 Close method
vbDataActionUnload 11 The form is being unloaded

Beginning-Of-File Action Constants

Constant Value Description
vbMoveFirst 0 Move to first record
vbBOF 1 Move to beginning of file

End-Of-File Action Constants

Constant Value Description
vbMoveLast 0 Move to last record
vbEOF 1 Move to end of file
vbAddNew 2 Add new record to end of file

Recordset-Type Constants

Constant Value Description
vbRSTypeTable 0 Table-type recordset
vbRSTypeDynaset 1 Dynaset-type recordset
vbRSTypeSnapShot 2 Snapshot-type recordset