mutually exclusive check box in continuous form

[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

 

[Question Boy]

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