#name? message in control box

[zachnjoe]

I have the following expression as my Controlsource. [PEN] is calculated
elsewhere on my form and [PEN_MAX] is pulled from table [WPS Data]. I keep
getting the error message.

=IIf([PEN]=[WPS Data]!PEN_MAX,"Bad","Good")

 

[KARL DEWEY]

Try replacing [PEN] with the calculations used for [PEN].

 

[KARL DEWEY]

OR reference [PEN] like this --
[Forms]![YourFormName]![PEN]

 

[Klatuu]

In a control source, it will need an =
=[Forms]![YourFormName]![PEN]

OR reference [PEN] like this --
[Forms]![YourFormName]![PEN]

I have the following expression as my Controlsource. [PEN] is calculated
elsewhere on my form and [PEN_MAX] is pulled from table [WPS Data]. I keep
getting the error message.

=IIf([PEN]=[WPS Data]!PEN_MAX,"Bad","Good")

 

[zachnjoe]

The title of my form is [MAIN FORM]. I don't understand what I should put in
the [Forms] box. I new to Access.

IIf([Forms]![MAIN FORM]![PEN]=[WPS Data]!PEN_MAX,"Bad","Good")