INFO: List of Values for Action Parameter of Validate Event

Last reviewed: October 30, 1997
Article ID: Q175949

The information in this article applies to:

Microsoft Visual Basic Professional and Enterprise Editions for Windows, version 5.0
Microsoft Visual Basic Professional and Enterprise Editions, 16-bit and 32-bit, for Windows, version 4.0

SUMMARY

The following is a complete list of all possible settings for the action parameter of the Validate Event for the Microsoft Data Control. The first 12 are documented in the online Help and the Microsoft Visual Basic Language Reference under the description of the Validate event.

MORE INFORMATION

The action parameter of the Validate Event of the Microsoft Data Control is populated with the notification that is sent to the control from the Data Access Objects (DAO). The action parameter is documented in Visual Basic to have the following valid settings:

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 has been set.
vbDataActionClose       10   The Close method.
vbDataActionUnload      11   The form is being unloaded.

There are 22 additional possible notifications from DAO that were not documented because they should not normally occur in a Visual Basic application. Most of these notifications are either not passed on to the action parameter of the Validate Event and simply ignored, will cause an error to be raised, or are mapped to one of the documented settings. Under certain conditions, it is possible that one of the following values is passed to the action parameter of the Validate Event. The following is a list of those values:

VALUE           DESCRIPTION

12              Rollback
13              Data Read
14              Data Save
15              Move Relative
16              Index Changed
17              Field Updated
18              Row Fixup
19              Refresh All Rows
20              Refresh Bookmark
21              Refresh Condition
22              Requery Parameters
23              Requery Definition
24              Schema Change
25              Order or Rows Change
26              Row Hidden
27              Seek
28              PercentPosition Move
29              AbsolutePosition Move
30              CancelUpdate
31              Cascading Update
32              Cascading Delete
33              Edit

NOTE: Because these settings should not normally be generated, they should not be relied upon or used. This article is for documentation and debugging purposes only. Any value that is not documented in the online Help for bound controls and is subject to change.

REFERENCES

Further information on these values and other data binding issues can be found in the Data Binding SDK documentation available on www.microsoft.com.

Keywords          : PrgOther vb432 VB4WIN vb5all
Version           : WINDOWS:4.0,5.0
Platform          : WINDOWS

================================================================================

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: October 30, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.