Combining Check Values

W

Wanda

I have used the Change Value function for when a check box
is True to populate the "txtLocation" text field, but when
I select the next check box (meaning I want to populate
the txtLocation text field with both addresses), it erases
my first address and puts in the second one. How can I
change the code to append the next address selected?

Select Case Name
Case "chkSpectrum"
If chkSpectrum = True Then
txtLocation.Value = "[email protected]"
End If

Case "chkSitt"
If chkSitt = True Then
txtLocation.Value = "[email protected];"
End If

Thanks. Wanda
 
Top