Hi everyone,
I have this code that includes the name of people responsible for one department if I click on the "checkbox" Yes/No button, it adds the name of the person into the textbox
But Now I want to delete the name of the person If I check this out
Any suggestion how to do it?
'****My Code****
If Me.WT_Quality = -1 And Len(Me.EquipoM & vbNullString) = 0 Then
Me.WorkTeam = DLookup("[Name]", "[Work_Team]", "[Departament]= 'Quality'")
ElseIf Me.WT_Quality = -1 And Me.WorkTeam <> "" Then
Me.WorkTeam = Me.WorkTeam & " " & vbCrLf & DLookup("[Name]", "[Work_Team]", "[Departamt]= 'Quality'")
End If
'Note.... I cannot just simple do something like If Me.WT_Quality = 0 Then Me.WorkTeam = "" because I have more names included into the same textbox
'*******SECOND PART AND THE QUESTION********
If Me.WT_Quality = 0 Then
Me.TeamWorktxt = DLookup("[Name]", "[Team_Work]", "[Departament]= 'Quality'" 'What would be the function to take the name out? Just to take out the name of the Quality guy and not of the others...
'THANK YOU VERY MUCH FOR THE HELP!!!