Validation in main and subform

[crxftw]

Hello. I need help to figure out how I can verify that the number (Hours) I have entered in my main form match to the number I have to enter in my sub-form. In my database I assign total hours worked for one sale and then there is an employees tab where I have to put how many hours each or one employee (depending how many were working for that sale) worked. For example if total hours for a sale are 4. And 2 employees work for that then I (usually) split it 2 and 2 for both. But how I can make a validation check so that I don't make a mistake before saving the data in tables. Sale hours must always be equal to the sum of hours that are assigned for employees. Attached a picture how the forms are set up. Hope you can help!

[RuralGuy]

Perhaps this link is what you are seeking: http://access.mvps.org/access/forms/frm0031.htm

[crxftw]

If I refer to unbound field in subforms footer which sums the employee hours then this way I must enter employee hours BEFORE filling the hours on Sale Details page in order to get this validation to work, but perfect way would be if I enter hours on Sale Details first, then fill the hours on Employee hours, and before submitting I get a notification that I am aware of Employee hours exceed the Sale Details hours so, because it actually can sometimes not be equal. If that makes sense.

[RuralGuy]

Is there a question in there?