Multi Item Form checkbox Selection

[lalit81]

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
Next
End If
End Sub

[ranman256]

This is exactly what queries are for.
like saying I want to get into my house without using any doors.

the query should set all flags to false,except the current key ID.

[Bob Fitz]

Is the check box bound to a field in the form's record source.

[lalit81]

the query should set all flags to false,except the current key ID. yes certainly not current key Id but the ID against whose checkbox is clicked

[lalit81]

YES checkbox is bound to the field any idea how to proceed further then

[Bob Fitz]

Code in the AfterUpdate event of the check box to execute an Update query that will change the table field of all records to 0 (false) except the record with the current ID

[lalit81]

Dear I already mentioned in the post i dont want to use update query and any LOOP concepts I am looking for other way

[Bob Fitz]

Code required would be something like:

Dim SQL as string
SQL = "UPDATE Table1 Data2.[YourFieldName]= 0 WHERE (((Table1.ID)<> Me.ID))"
Currentdb.Execute (SQL)

[Bob Fitz]

Dear I already mentioned in the post i dont want to use update query and any LOOP concepts I am looking for other way

What is the objection to using Update query

[lalit81]

Dear BOB as i am having huge amount of data n multiusers that's the reason i am not preferring to use a query

[Bob Fitz]

Dear BOB as i am having huge amount of data n multiusers that's the reason i am not preferring to use a query

Sorry, but I don't understand how or why that would make the use of a query objectionable. On the contrary, I should have thought that with a "huge amount", whatever that means, using a query would be the best method.

[June7]

Your only options for this sort of batch edit are UPDATE query or looping.

Multiple simultaneous users will likely conflict with each other in editing this field.