Checkbox in forms

[adi.shoukat]

Hi,
I am worried how would I make decisions in MS access depending on weather my checkbox is checked or not ...

What I want is:
I have three check boxes: box1, box2, box3 (Say)

If box1 is checked I want the criteria for a particular field to be:
"Box1_"


If box1 and box2 are selected it should be: "Box1_" || "Box2_"
And if box1, box2 and box3 are selected it should be: "Box1_" || "Box2_" || "Box3_"

Can anyone please help me with this ???

[SoftwareMatters]

On the afterupdate of each checkbox and the oncurrent of the form you will need some code to run. I would write a Sub and call it where I mentioned earlier. The function will be something like this:

Private Sub UpdatetextField()
Dim TextStr as String
TextStr = ""
If Me!Box1 = True Then TextStr = "Box1_"
If Me!Box2 = True Then
If TextStr <> "" then TextStr = TextStr & " || "
TextStr = TextStr & "Box2_"
End If
If Me!Box3 = True Then
If TextStr <> "" then TextStr = TextStr & " || "
TextStr = TextStr & "Box3_"
End If
Me!TextBox = TextStr
End Sub