Using If & And

H

Hoopster

I have something I'm trying to do and am not sure if I can. I have two
different Controls on a Form that if Control 1 says one thing the Control 2
cannot be Null. I am trying to use the following Code:

If (Me.[Pass/Repair/Reject]) = "Repair" And (Me.[Repair/RejectComments]) Is
Null Then

Save_and_Mailpromt = MsgBox("Please Check Your Data. Cause Code Can Not
Be Empty When Total Number of Rework for this Cause Field Has Been Filled
In!", vbOK, "OhioData")

[Forms]![CellAudits]![RepairNumber].SetFocus

End If

Any Hope?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

If one thing and another thing 4
Change Forecolor based upon if statement 2
clearing the values of all the controls in a form 1
If else subform reference access 2007 2
if a # then sum, if text leave null 2
Test for a Combo Box empty or not... 5
Matching literal text "???" in Word 2010 field code IF statement 2
<= 0 11

Top