Expression written to a Form

[Holli]

Needs some help.

I have an expression that I have written to form.

If IsNull([Coding Errors]) And IsNull([MM changes after WF sent]) Then
 [Note].Value = ""
Else
[Note].Value = "Note is required"

This is working fine. I need to add another requirement. If the [Note Included] checkbox is clicked then
The [Note].Value is "Note is present".

I have tried writing this several different ways with no luck. Either the "Note is present" is on every record or the first expression doesn't work at all.

Thanks for any help.

Holli

[ssanfu]

Not sure what you want. Not enough code to see where you are headed.

Maybe this???

    If IsNull([Coding Errors]) And IsNull([MM changes after WF sent]) Then
        [Note].Value = ""
    Else
        If [Note Included] Then
            [Note]= "Note is present"
        Else
            [Note]= "Note is required"
        End If
    End If

* "Value" is the default property and doesn't need to be typed - doesn't hurt, but not necessary.
* Shouldn't use spaces in object names. ( CodingErrors is a better field name than [Coding Errors] )
* "Note" is a reserved word in Access. Here is a list of reserved words:
http://www.allenbrowne.com/AppIssueBadWord.html

[Micron]

If the first part returns true, the else is not processed, no? ssanfu is correct in that you have not provided enough info. If your new requirement is not dependent on the other two, it is just another if, then, end if clause. Otherwise, it may need to be nested.

[Holli]

Thanks Steve and Micron

The [NotesIncluded] = "Note is Present" is a separate requirement by itself.

When I try write it as new requirement it doesn't work Or the first requirement doesn't work.

I need to use a nested statement?

Thanks for your help and the link.

Thanks

Holli

[ssanfu]

Post more of the code and indicate where you think it should go.
If it is a separate requirement, this should work:

        If [Note Included] Then
            [Note]= "Note is present"
        End If

But without seeing the code, it is really hard to say where it should go.
What is "[NotesIncluded]"? the name of a control on the form or a field on the record source?

[Holli]

Working, PERFECT!
Thanks

If IsNull([Coding Errors]) And IsNull([MM changes after WF sent]) Then
 [Note].Value = ""
Else
[Note].Value = "Note is required"
End If
If [Note Included] Then
[Note] = "Note is present"
End If

Thank you

Holli

[ssanfu]

Wonderful...