Hi Haneef,
Thanks for the link. The content was informative, but didn't seem to apply to my specific situation.
I'm trying to get the following behavior:
1) When a user clicks the 'tab' key within an unchanged cell, the current cell moves one cell to the right. If the current cell is the right-most cell,t he current cell should loop around to the first cell in the next row.
2) When the user clicks the 'tab' key with an edited cell, I want the CellValidating event to fire (which sends the updated value to the database), then the current cell should move one cell to the right. Again, if the cell is the right-most cell it should loop around the first cell in the next row.
I can't seem to get this behavior. Currently if the user presses the tab key without editing anything everything works as expected. The current cell moves and loops around to the next row just fine.
However if the user edits a cell and clicks the 'tab' key, the validating event fires and the validation happens, but the current cell remains current.
Any thoughts on how I can fix it?
Thanks,
Chris Rutledge
>Hi Chris,
Please refer to this KB article(
What are the different validation events and event members? When are they triggered and how are they used? ) for more details on Validation of a cell. This will help you.
Best regards,
Haneef