Check box automation

[prabhus]

Hi,

In my access form, i have four check box ( 3+1), from this, if the user select any one or more than one check box from the first three boxes, i want the fourth one to check automatically, is it possible? please help!

 

[pr2-eugin]

Something along the lines of..

Private Sub [COLOR=Blue]chkBox1[/COLOR]_AfterUpdate()
    updateLast
End Sub

Private Sub [COLOR=Blue]chkBox2[/COLOR]_AfterUpdate()
    updateLast
End Sub

Private Sub [COLOR=Blue]chkBox3[/COLOR]_AfterUpdate()
    updateLast
End Sub

Private Sub updateLast()
    Me.[COLOR=Blue]chkBox4 [/COLOR]= Me.[COLOR=Blue]chkBox1 [/COLOR]Or Me.[COLOR=Blue]chkBox2 [/COLOR]Or Me.[COLOR=Blue]chkBox3[/COLOR]
End Sub

Change the names of the Check box though.

 

[Mihail]

The 4th checkbox has a calculated value so, is no need for this checkbox at all and is no need for the field where that checkbox is bounded (if any)

 

[prabhus]

Something along the lines of..

Private Sub [COLOR=blue]chkBox1[/COLOR]_AfterUpdate()
    updateLast
End Sub
 
Private Sub [COLOR=blue]chkBox2[/COLOR]_AfterUpdate()
    updateLast
End Sub
 
Private Sub [COLOR=blue]chkBox3[/COLOR]_AfterUpdate()
    updateLast
End Sub
 
Private Sub updateLast()
    Me.[COLOR=blue]chkBox4 [/COLOR]= Me.[COLOR=blue]chkBox1 [/COLOR]Or Me.[COLOR=blue]chkBox2 [/COLOR]Or Me.[COLOR=blue]chkBox3[/COLOR]
End Sub

Change the names of the Check box though.

its working thank you

 

[pr2-eugin]

You are welcome ! Good Luck !