Ticking Checkbox Upon Clicking Button on Form

[lil2lam]

Hello -

I am still a little new to forms, buttons, checkboxes, and binding stuff....so please, any details will help greatly !!



I have created a form.
In the form I created 5 buttons.
Each button will run a set of queries or code upon clicking them.

I want to create 5 checkboxes right next to these buttons.
I want each checkboxes to automatically check upon clicking each button that is next to the check box.

Can anyone help me with this ??

[redbull]

I got ya, Look at the code below. On my form I have 2 options, when they hit a button I want to check to see if those buttons have value, if they do then I call another routine...

Private Sub cmdRun_Click()
MsgBox "Depending on the size of the report, there might be a delay.", vbOKOnly, "LIFT"
If opWest.Value = True Then
Call WestHills
End If
If opWest.Value = False Then
End If
If opPhilly.Value = True Then
Call Philly
End If
If opPhilly.Value = False Then
End If
MsgBox "Reports are ran.", vbOKOnly, "LIFT"
End Sub

Might be able to skate with this,

Private Sub cmdRun_Click()
MsgBox "Depending on the size of the report, there might be a delay.", vbOKOnly, "LIFT"
If opWest.Value = True Then
Call WestHills
End If
If opPhilly.Value = True Then
Call Philly
End If
MsgBox "Reports are ran.", vbOKOnly, "LIFT"
End Sub

--Edit--
Sorry for stringing this along, I just re read your post... seems like you want to make the check mark appear after the button is hit... I am using some google fu, however I can't get anything to work.

[redbull]

If that works, PLEASE let me know. I am new at all of this and I like to help out when I can. BTW I am sure there is a better way of handling this, but this is how I was able to get it working.

[Bob Fitz]

Hello -

I am still a little new to forms, buttons, checkboxes, and binding stuff....so please, any details will help greatly !!

I have created a form.
In the form I created 5 buttons.
Each button will run a set of queries or code upon clicking them.

I want to create 5 checkboxes right next to these buttons.
I want each checkboxes to automatically check upon clicking each button that is next to the check box.

Can anyone help me with this ??

Try this line of code in the On Click event of a button:

Me.NameOfYourCheckBox = Not Me.NameOfYourCheckBox

[redbull]

I just tried that on my form, did not seem do anything. The option I tried on was an independent option, not inside the frame or option grouping. I'm not sure if that would make a difference.

[Bob Fitz]

Try setting the controls "Default Value" property to False.