Hi,

I have a form which has rows of 5 textboxes.

Each row of textboxes needs to be validated for Emptiness.

The Validation rules that need to be applied to each row of textboxes
a

1] All textboxes in a row can be EMPTY, or All ZERO.

2] If one or more are NOT EMPTY, then Error MsgBox should be
displayed, and Focus should be set on each of them, one by one, and
they should be filled in, in order to move ahead.

3] The Cumulative total of all 5 TextBoxes (if filled), should not be
102.


TextBoxes look something like this:

lbl_Loyalty --- txt_VeryStrong txt_Strong
txt_Medium txt_Weak txt_VeryWeak --- (Total <=102)

lbl_Dedication --- txt_VeryStrong txt_Strong txt_Medium
txt_Weak txt_VeryWeak --- (Total <=102)

lbl_Empathy --- txt_VeryStrong txt_Strong txt_Medium
txt_Weak txt_VeryWeak --- (Total <=102)


I tried Exit & Enter events for each textbox, but if i set
Cancel=true, then the cursor does not leave the Active textbox which
has focus right now, even though it may be filled and there may be
other textboxes which are empty. I think the Empty validation check
should be evaluated not from a textbox event but from outside. I am
right now Stumped!.

Anyone come across something like this? Any ideas?