Originally Posted by
OBP
When you say "I cant get it to work like it should with your example." do you mean the database that I posted doesn't add record or update a record when it has been changed?
So if lngPosID has to be zero how can you put it in the tblEmployeeLevel table, because it cannot accept a zero as it does not exist in the Level table?
I obviously do not understand that part of your code.
Ok, the reason the lines:
ElseIf DCount("*", "tblEmployeeFunctions", strCriteria) = 7 Then
lngPosID = 0
ElseIf DCount("*", "tblEmployeeFunctions", strCriteria) = 5 Then
lngPosID = 0
ElseIf DCount("*", "tblEmployeeFunctions", strCriteria) = 3 Then
lngPosID = 0
Were put in was there isn't a position for those numbers and when an employee completes a functional area and completes all its requirements it wants to put a position in tblEmployeeLevel so for each one of those it puts a 2 which is "Operator 2" thats and by using that line that puts a stop to that and puts a stop to entering of data at that time on 3,5,7.
Now for your example, I kinda get what your dong but it enters the record right off the bat without completing the requirements. The textbox txtCompletedInCompleteReq is a 0 if they are not all completed and if they are it a 1 is there a way to incorporate that into the recordset?