Re: Display Message for Each Rec in Subform.

From: "ApexData@xxxxxxxxx" <ApexData@xxxxxxxxx>
Date: 28 Apr 2006 16:45:05 -0700

"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")

.

References:
- Display Message for Each Rec in Subform.
  - From: ApexData@xxxxxxxxx

Prev by Date: Re: How can I Insert into a table with data from a form
Next by Date: Re: Relationships. Does anyone use them?
Previous by thread: Display Message for Each Rec in Subform.
Next by thread: Generate report based on selected value
Index(es):
- Date
- Thread

Relevant Pages

RE: how do i create a combo box?
... > The index, beginning with 1, of the column to be stored in the ControlSource ... > fields, and that you'd like to display them in "LastName, FirstName" format, ... > Finally, to display any of the other columns in a separate textbox, use the ... >> be able to select the first and last name for an employee, ...
(microsoft.public.access.forms)
RE: how do i create a combo box?
... > The index, beginning with 1, of the column to be stored in the ControlSource ... > fields, and that you'd like to display them in "LastName, FirstName" format, ... >> is based on fields from one table that lists the employees names. ... >> be able to select the first and last name for an employee, ...
(microsoft.public.access.forms)
Re: Lookup text box
... the 2 selections from the fields. ... i.e. display an output of site ref/ ... to use the exisiting keys to provide a new output) ... Create an unbound textbox and in the control source enter ...
(comp.databases.ms-access)
Re: Inspections and Treatments
... Customer's address in a comboBox? ... be a need to display many addresses. ... For example, in my particular model, while the customer calling ... ControlSource) and experimented with them, ...
(microsoft.public.access.tablesdbdesign)
Re: Open a form, using a sql string.
... ControlSource to the appropriate field name. ... to include all the table fields in the form's RecordSource. ... of the table field you want to display. ... second form's Load event, to set the control's ControlSource to Me.OpenArgs. ...
(microsoft.public.access.forms)