Subform wont update

[oxicottin]

I have a question about practicallity with regards to the frmEmployeeFunctionsSubform which displays the Functional Areas achieved, why do you not use the same display method as the frmRequirementsSubform, ie show all the functions in order.
Currently you can select any of the Functions regardless of whether the previous required functions have been met, but the only 2 that should be allowed to be entered first are the Supply & Packaging.
If they were all displayed it would be easier to control which ones were allowed to be entered.

I would like to display all the Functional areas at once but wouldnt that mean there would be a records created in frmRequirementsSubform for each of them? Some employees might never do some of the requirements for one of the functional areas so then I would have records/data I dont need right or maybe im wrong? Thats what I originally wanted to do...

Also should the Date Completed only be entered when all the Requirements have been met instead of after each requirement?

Yes

When you say goofy what actually happens?

It starts working backwards its like the line If Me.txtCompletedInCompleteReq < 1 Then is now > and instead of one field being null and the other applying a date they switch... in txtDateCompleted_Change()