General information
Category:
Coding, syntax & commands
Title:
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only