Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How can I validate information using adodc data control before an upda

Status
Not open for further replies.

hoggle

Programmer
Joined
Jul 13, 2001
Messages
124
Location
US
I need to know how I can trigger a method to validate some user entered text (on a bound text box) before the update command runs on my adodc data control (ado 2.6)

Also I need to be able to stop the update if the data is invalid.

thanks
 
Try using the text box's Validate event. If you set the argument:
Cancel = True
Then the field shouldn't be changed in the recordset.

You can also look into the Adodc events:
Adodc1_WillChangeField
or
Adodc1_WillChangeRecord

and validate/cancel the changes/update there.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top