S
Steve Goodrich
I use up to 6 check boxes to populate the same memo field
When I click the first check box "Ph1" the text is entered into the memo
field on a new line "PATROL OF PHASE 1" - this works great for my needs.
I have 6 of these check boxes Ph1 to Ph6
If I check the wrong box I simply uncheck it but the text still remains in
the memo field
MY QUESTION
How do I delete just the text for the relevant check box if I uncheck It,
without deleting the other entries in the same memo field?
The code I am using is as follows.The memo field is called "Incident"
Private Sub Ph1_Click()
If Me.Ph1 = True Then
Me.Incident = Me.Incident & vbCrLf & "PATROL OF PHASE 1"
End If
End Sub
Any help would be appreciated
Steve
When I click the first check box "Ph1" the text is entered into the memo
field on a new line "PATROL OF PHASE 1" - this works great for my needs.
I have 6 of these check boxes Ph1 to Ph6
If I check the wrong box I simply uncheck it but the text still remains in
the memo field
MY QUESTION
How do I delete just the text for the relevant check box if I uncheck It,
without deleting the other entries in the same memo field?
The code I am using is as follows.The memo field is called "Incident"
Private Sub Ph1_Click()
If Me.Ph1 = True Then
Me.Incident = Me.Incident & vbCrLf & "PATROL OF PHASE 1"
End If
End Sub
Any help would be appreciated
Steve