By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
445,841 Members | 1,761 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 445,841 IT Pros & Developers. It's quick & easy.

Display Message for Each Rec in Subform.

P: n/a
I have a Subform in a Mainform that displays the service event history
the single product displayed in the maintform. The ChildParent in based
the SerialNo.

I am unable to get each row in the Subform (service event history) to
"OPEN" or "CLOSED" based on the ServDateClosed field being null or

I placed the following code in the OnCurrent of the Subform but it only
seems to
process the first record and then repeats that assigned value over and

If (Is Null (ServDateClosed) Then
Me.txtDispSrvStat = "OPEN"
Me.txtDispSrvStat = "CLOSED"
End If

I also tried to place the following code in the ControlSource of an
unbound textbox
use for the display, but get an error.
=IIf (Is Null(ServDateClosed),"OPEN","CLOSED")


Apr 28 '06 #1
Share this Question
Share on Google+
1 Reply

P: n/a
"False Alarm"

I figured it out! I placed the following code in the ControlSource of
an unbound textbox
used for the display:

=IIf([ServDateClosed] Is Null,"OPEN","CLOSED")

The following had flawed syntax:
=IIf (Is Null ServDateClosed),"OPEN","CLOSED")

Apr 28 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.