IIf failing:Control can't be edited, it's bound to the expression

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

IIf stmt: =IIf([BuildingPermit]>0,[Forms]![Building Permits]![Owner],Null)
Goal: Automatically complete fields if tied to record on the "one side," and
to allow new information to be entered if not tied to another record.
Automaticall fills in successfully, but will not allow anything to be typed
in when the first part of expression returns false. Have tried Null and ""
at the end of the statement.
 
I get the same response.

Kou Vang said:
What happens if you leave it off completely? Remove the last condition for
false?

joanne said:
IIf stmt: =IIf([BuildingPermit]>0,[Forms]![Building Permits]![Owner],Null)
Goal: Automatically complete fields if tied to record on the "one side," and
to allow new information to be entered if not tied to another record.
Automaticall fills in successfully, but will not allow anything to be typed
in when the first part of expression returns false. Have tried Null and ""
at the end of the statement.
Click to expand...
Click to expand...
 
Where are you using this? On a control on a form? In some vba? As the
default property for a control? In a query?

In a query, this won't be updatable as it is a calculate field and
calculated fields are not updatable.
If as the control source of a control, again it won't be updateable since it
is calculated.
 
I am trying to automate fields on a form, and using it as the Control Source.
There must be some way to have the option of having these fields either
default to existing information, or complete with new information??

John Spencer said:
Where are you using this? On a control on a form? In some vba? As the
default property for a control? In a query?

In a query, this won't be updatable as it is a calculate field and
calculated fields are not updatable.
If as the control source of a control, again it won't be updateable since it
is calculated.



joanne said:
IIf stmt: =IIf([BuildingPermit]>0,[Forms]![Building Permits]![Owner],Null)
Goal: Automatically complete fields if tied to record on the "one side,"
and
to allow new information to be entered if not tied to another record.
Automaticall fills in successfully, but will not allow anything to be
typed
in when the first part of expression returns false. Have tried Null and
""
at the end of the statement.
Click to expand...
Click to expand...
 
Back
Top