Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recording information from multiple check boxes in to list

Status
Not open for further replies.

act2

Technical User
Dec 17, 2005
34
US
I have a form with 5 check boxes, the check boxes relate to answers the user must select. I would like to record the answers in a sub form list. I have the code so it will show if one of the check boxes is selected but not multiples. Not sure how I would do that.


Code:
Option Compare Database
Option Explicit
Private Sub cmdEnter_Click()


Dim ctl As Control
   Dim Ck As String
   
   For Each ctl In Me.Controls
      If ctl.ControlType = acCheckBox Then
      If ctl.Value = True Then
      
      

                Me.test = ctl.Controls(0).Caption
      
      Exit For
         End If
     End If

   Next


End Sub
 
Sorry I posted this in the wrong forum
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top