Function to delete infortmation contained into a textbox

[charly.csh]

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!!!

[pbaldy]

Was I too slow?

https://www.accessforums.net/showthr...911#post452911

[charly.csh]

Oh no sorry!!!
I just thought you were busy :$ :$

and I highly happy to see that this is working pretty fantastic!!!