Information générale
Catégorie:
Codage, syntaxe et commandes
Titre:
How to validate a row in a grid ??
Hello everybody !!
I'm searching for an easy way to validate a row in a grid!?
I have a cursor "X" as result from an sql-select command!
In my form i have a grid1 with n columns (textboxes or comboboxes in the columns)
Some of these objects have code at the valid event! (if .. messagebox...return 0)
myform.grid1.recordsource = "X"
I want to validate all textboxes/comboboxes of the aktice row in the grid at the
beforerowcolchange event (if rowcolchange = 1 or 3 )
The the validation returns 0 the user can not change the row, and the object with the
wrong validation must have the focus(be the active cell?)!
example:
user enters data in column1 of row3
user changes the row (click on row6)
row3 is validated, textbox in column5 of row3 returns 0, messagebox and focus on column5 of row3
Any help welcomed
Best regards
Albert
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement