how to handle check box 1

[JavaToPerlNowVB]

I have a form which has for subforms which are get feeded by four queries. I created 4 check boxes in the main form. I want each subform to showup the data depend on the check box that user select
Example

If "checkbox is click"
    run this query
       :
       :

I don't know how to handle the syntax of check box values.

thanks

 

[AlexMidd]

Sub CheckBox_AfterUpdate
    If CheckBox then
        ... do things here
    Else
        ... do other things here
    End If
End Sub

Have fun! )

Alex Middleton

 

[JavaToPerlNowVB]

Can i do this in update button code, in that way I only have to yse

if CheckBox then 
   do something
else

thanks

 

[JavaToPerlNowVB]

I have this if statement and, and want to stop going further if the conditions are not true but it doesn't happen

Private Sub WorkOrderUpdate_button_Click()
On Err GoTo err_WorkOrderUpdate_button_click

    If IsNull(WorkOrderUpdate_Text) Then
        MsgBox "Please enter Work Order"
    ElseIf IsNull(New_WorkOrder_Text) Then
        MsgBox "Please enter new work order"
    End If

after this i have some other conditions, but i want the program to be stop when these conditons fail

 

[PHV]

Have a look at the Exit Sub instruction.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[JavaToPerlNowVB]

Thanks alot it works fine,