I am trying to build an MS Access database that can be used to send bulksms.
The problem am facing has to do with how the recipient textbox (ttcontact) on a form can be populated with phone numbers (separated with commas) when they are checked in checkboxes.
I researched a little and was able to come up with the vba codes below but they only display the latest contact checked in the checkbox
Attached is a picture of how the form looks like.
Please kindly help.
The problem am facing has to do with how the recipient textbox (ttcontact) on a form can be populated with phone numbers (separated with commas) when they are checked in checkboxes.
I researched a little and was able to come up with the vba codes below but they only display the latest contact checked in the checkbox
Code:
Private Sub Select_AfterUpdate()
If Me.Select.Value = True Then
Me.ttContact.Value = Me.MobilePhone.Value
' etc.
Else: Me.ttContact.Value = Null
End If
End Sub
Attached is a picture of how the form looks like.
Please kindly help.