How to output data from multiple choice

[oppoiste0731]

Creating a page for users to find information by clicking a button use as an Email, TEL, MOBILE , But there is the constraint in multiple option fields at "Group" It has plenty of options for users to choose at least 1-6 options in a row
because of some client assigned in specific group.

[Minty]

I'm confused as to what your question is?

[ranman256]

if the user can pick more than 1 method, would you want to send data to ALL devices? or just 1?

if you are sending to all , cycle thru each checked item then send it, like:

Public Sub btn_test_Click()
Dim rst
dim vMethod, vID


Set rst = CurrentDb.OpenRecordset("qsContactResults")


With rst
    While Not .EOF
         vID = .Fields("ID").Value & ""
         vMethod = .Fields("Contact").Value & ""
         SendViaMethod vID, vMethod  
        
        .MoveNext
    wend
    .Close 'Close the recordset
End With
Set rs = Nothing 'Clean up
End Sub




sub SendViaMethod(byval pvID, byval pvMethod)


select case pvmethod
   case "Email"  
       sTo  = Dlookup("[email]","tContacts","[id]=" & pvid)
       docmd.SendObject acSendReport ,"rMyReport",acFormatPDF,sTo,,,sSubj,sBody


   case "TEL"
      'send to TEL


   CASE "Mobile"
       'send to phone
end select
end sub

[ssanfu]

From the image in Post #1, it looks like you have multi-value FIELDS in your tables. Most experienced Access developers do not use MVFs.

Some suggestions:
Use only letters and numbers (exception is the underscore) for object names.
Do not use spaces, punctuation or special characters in object names.
Do not use look up FIELDS, multi-value fields or calculated fields in tables.
Do not begin object names with a number.