If one thing and another thing

[Hoopster]

I have two controls where if the 1st control says one thing and the 2nd
control is Null, I want to alert the user to check their data. Is this
possible?

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

 

[Stuart McCall]

I have two controls where if the 1st control says one thing and the 2nd
control is Null, I want to alert the user to check their data. Is this
possible?

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

You need to make one small change. Use the IsNull function instead of Is
Null (notice the space), which is only valid in queries.

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

 

[Larry Linson]

It is certainly possible, but to test for the Control having a Null value,
you must use the IsNull function, to wit,

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

"Is Null" works in Query Criteria, but not in VBA code.

Larry Linson
Microsoft Office Access MVP

 

[CrazyAccessProgrammer]

Just another tidbit that might come in handy for you when checking for null
values:

The following statement EXPLICITLY checks if a null value:
if isnull(Me.MyField.Value))=True Then

And Conversely you can check if a value is NOT NULL with:
if isnull(Me.MyField.Value))=False Then

It is certainly possible, but to test for the Control having a Null value,
you must use the IsNull function, to wit,

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

"Is Null" works in Query Criteria, but not in VBA code.

Larry Linson
Microsoft Office Access MVP

I have two controls where if the 1st control says one thing and the 2nd
control is Null, I want to alert the user to check their data. Is this
possible?

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

 

[haunt]

http://itlinks.co.cc/difference-between-cisco-memory-modules-and-third-party-counterparts/
http://itlinks.co.cc/10-quick-tips-to-speedup-windows-xp/
http://itlinks.co.cc/how-to-help-prevent-computer-viruses/
http://itlinks.co.cc/advanced-troubleshooting-tips-for-general-usb-problems-in-windows-xp/
http://itlinks.co.cc/making-the-usb-thumb-drive-bootable/
http://itlinks.co.cc/where-to-download-free-anti-virus-and-anti-spyware-software/
http://itlinks.co.cc/how-to-remove-the-virus-and-spyware/
http://itlinks.co.cc/virus-in-windows-system-registry/
http://itlinks.co.cc/how-to-remove-the-spyware-or-adware/
http://itlinks.co.cc/uninstall-spyware-programs-from-control-panel/
http://itlinks.co.cc/how-to-use-msconfig/
http://itlinks.co.cc/how-to-start-windows-xp2000-in-safe-mode/