Checkbox control

[honey2wood]

Hi

I have a form for recording part details.
Some of the details I require are within a subform. This subform has 2 fields. one is the position is a process the part is the other is a check box.
As the part moves through the process the box is ticked to say where it is in the process. This then displays at what point in the process the part is in.
Thats all fine but if someone forgets to untick a part of the process the item can be in two or more different states.
What I need is a way to only have one box ticked in the subform at any one time.

I have tried
Private Sub Checking_Click()
If [Form]![Checkbox 1] = True Then


'[Form]![Checkbox 2]= False
'[Form]![Checkbox 3] = False
End If
End Sub
But this doesn't work. I think it is close but not quite there

Thansk for reading this and for any help you can give.

Graham

[Toyman]

Hi

I have a form for recording part details.
Some of the details I require are within a subform. This subform has 2 fields. one is the position is a process the part is the other is a check box.
As the part moves through the process the box is ticked to say where it is in the process. This then displays at what point in the process the part is in.
Thats all fine but if someone forgets to untick a part of the process the item can be in two or more different states.
What I need is a way to only have one box ticked in the subform at any one time.

I have tried
Private Sub Checking_Click()
If [Form]![Checkbox 1] = True Then
'[Form]![Checkbox 2]= False
'[Form]![Checkbox 3] = False
End If
End Sub
But this doesn't work. I think it is close but not quite there

Thansk for reading this and for any help you can give.

Graham

Use a Option Group instead. The Option Group consist of check boxes, each represents a value from 1 to as many check boxes you have. The Option Group then takes on the value depending on which check box is checked. One one check box can be checked at any time. You can then bound your control to the option group.