Checkbox problem if Yes or No

[Amen]

I'm new to access database. I have a check box "Yes" or "No" to choose...all i want, if i check "YES" it continues to the next step..If "No" skip the next 3 or 4 steps and move to the other steps...I'm not sure how can i do this


can someone share some lights here..

thanks in advance

[ItsMe]

You can try the IF THEN ELSE statement. You can skip lines by using GoTo or enclose the code you want to execute after THEN and before END IF.

If Me.chkBox = -1 Then 'User ticked yes
MsgBox "User ticked Yes"
ElseIf Me.chkBox = 0 Then
msgBox "User ticked No"
Else
msgBox "This Yes No field has gone unchanged and is a Null value"
End if

Goto My_New_Line_Of_Code

MsgBox "I got skipped Over!"

My_New_Line_Of_Code:

MsgBox "THis is a good place to start"

[Amen]

thanks for your reply

Do i need to write this code on "on click" Under Events?

[ItsMe]

Build a new form. Name it something like Test or frmTest.

Go into Edit view. Turn off your wizard or if it starts, click cancel. You are going to add a couple controls.

Create a Checkbox and give it a name. Using the "Other" on the check box's properties name it chkBox

Create a Control Button and name it cmdTest

Create a sub routine for your Button named cmdTest. The sub routine will be a click event.

paste all of the code into the click event you just created.

Open your form and click the button you created. Then, change the value of your Check Box and click the button.


Not sure what your end goal is but the code I provided you is fairly intuitive. A light bulb might go off and your next question may be for a different subject. Update this thread regardless of the outcome.