affect form control value with another (1 Viewer)

[mhakim]

hi dears
good day

i wish to find code to enable and disable JV_Post Button
when check box is YES THEN JV_Post Button become enable = no

 

[theDBguy]

Have you tried the AfterUpdate event of the checkbox? If the checkbox is bound, you might also try the Current event.

 

[The_Doc_Man]

Checkboxes have a Click event, an AfterUpdate event, and a LostFocus event. One of these might be a perfect place to put code such as...

Private Sub JV_GL_Transfer_LostFocus()
    JV_Post = NOT JV_GL_Transfer
End Sub

Here is the general writeup for check boxes and in it you can see links to all of the events that apply to checkboxes.

CheckBox object (Access)

Office VBA reference topic

learn.microsoft.com

 

[mhakim]

check box is locked it already have automatic value i will not make any manual checking
so i just want to disable the button JV-Post when the check box value is yes

in other way
main idea for user is that if the check box is yes then he donot need to click button JV-Post

 

[MarkK]

Private Sub Form_Current()
'   the enabled state of the command button 
'   is the inverse of the value of the checkbox
    Me.cmdButton.Enabled = Not Me.chkBox
End Sub

 

[The_Doc_Man]

If the value for the check box comes from an underlying record, MarkK's suggestion of the Current event is probably the best choice.

 

[mhakim]

Private Sub Form_Current()
'   the enabled state of the command button
'   is the inverse of the value of the checkbox
    Me.cmdButton.Enabled = Not Me.chkBox
End Sub

very good thanks