Isn't this reversed? Shouldn't it be 'take the teacher_observno from the teacher table and subtract the total hours in the subform from that, so that
Originally Posted by Nokia N93
Text11 = teacher_observno - Sum([observ_hours])
If so, put this in the Control Source Property of the Text11 Control:
=DLookUp("[teacher_observno]","teacher","[TID] =" & [TID])-Sum([observ_hours])
Hope this helps!
The problem with making anything foolproof...is that fools are so darn ingenious!
All posts/responses based on Access 2003/2007