UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
> Multi Item Form Checkbox Selection, Access 2016    
 
   
lalit81
post May 22 2020, 08:21 AM
Post#1



Posts: 1
Joined: 22-May 20



I had created a multi item Form with the table as shown having a checkboxes .But If I select the checkbox all other chekcboxes should get clear only one can remain checked at a time. the form is shown below and code as well i dont want to use update query or for loop is there any way.
CODE
Private Sub chk_Click()
If chk.Value = -1 Then
MsgBox (ID)
Dim s As String
'MsgBox (chk.name)


MsgBox (chk.name)
Dim contr As Control
For Each contr In Me.Controls


    If TypeName(contr) = "CheckBox" Then
    
        contr.Value = False
      If contr.name = s Then
              contr.Value = True
    End If
     End If
Next
End If
End Sub

This post has been edited by lalit81: May 22 2020, 08:37 AM
Attached File(s)
Attached File  1590129596102.png ( 216.61K )Number of downloads: 11
 
Go to the top of the page
 

Posts in this topic



Custom Search


RSSSearch   Top   Lo-Fi    9th July 2020 - 12:10 PM