Using If Then with Check Box 1

[AT76]

Hi,

I'm trying to display a message if the user does not click on a couple of check boxes.

If Me.chBox1.Value = Null And Me.ckPTPRDDTAASI.Value = Null Then
MsgBox "You must a Check Box."
End
End If

However, the code ignores the If Then clause and keeps on going?

Any ideas what I'm forgetting to do?

Thank you!

 

[PHV]

If Not (Me!chBox1 Or Me!ckPTPRDDTAASI) Then

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

 

[AT76]

Thank you PHV... but it still didn't work. Any thoughts?

 

[PHV]

If the checkboxes are in an option group then check the value of the frame.

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

 

[AT76]

PHV, the checkboxes are not in an option group. Could it be anything else?

 

[PHV]

Perhaps this ?
If Not (Nz(Me!chBox1, False) Or Nz(Me!ckPTPRDDTAASI, False)) Then

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

 

[ItIsHardToProgram]

If Me.chBox1.Value = Null And Me.ckPTPRDDTAASI.Value = Null Then
    MsgBox "You must a Check Box."
    [highlight]End[/highlight]    
End If

Why End???????

 

[AT76]

PHV, That worked OK. Thank you! Could you explain why this approach finally worked?

ItIsHardToProgram - I guess you are correct. No need for End.

Thank you both!

 

[PHV]

Any expression containing a Null can't evaluate to True, thus the use of the Nz function.

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

 

[AT76]

Thank you PHV for all your help and explanation!