Hi,

I have a form, with a sub-form embedded in it. The sub-form displays NAME, TASK, PERCENT on it. The form uses a combo box with NAME to look up an individual's tasks and percent. I have a text box calculating a total percent on the sub-form. Then I have a text box on the main form refering to the sub-form based on who is selected by the combo-box.

I want to put a validation rule on the text box of the main form making sure no one is over 100.

I tried...
<101
on the validation rule section but it won't work. I tried a IF statement...it won't work. Is there something I'm missing?!?

PLEASE HELP
Thanks

Probably not, your referencing a calculated control on the sub for which data has already been entered, You will more than likely have to use an event procedure which includes the calculation.