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    
post May 22 2020, 08:21 AM

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.
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
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