mutually exclusive check box in continuous form

  • Thread starter Thread starter Question Boy
  • Start date Start date
Q

Question Boy

How can I build a continuous form with a text box and a checkbox for each
record that only allow the checkbox to be selected for a single record?
Basically if I have 5 records the user selects the 2nd check box and then
later go and select the 4th, it would uncheck the 2nd and check the 4th.

Thank you,

QB
 
Here is the solution I found using the click event of the check box

Dim rst As Recordset

Set rst = Me.RecordsetClone
With rst
.MoveFirst
Do While Not .EOF
.Edit
rst![CheckBoxFieldName] = False
.Update
.MoveNext
Loop
End With
rst.Close
Set rst = Nothing

I hope it can help someone else!

Qb
 
Back
Top