 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Modules / DAO / VBA / January 2006IIf failing:Control can't be edited, it's bound to the expression
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. What happens if you leave it off completely? Remove the last condition for false? > 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. > What happens if you leave it off completely? Remove the last condition for > false? [quoted text clipped - 5 lines] > > in when the first part of expression returns false. Have tried Null and "" > > at the end of the statement. 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. > IIf stmt: =IIf([BuildingPermit]>0,[Forms]![Building Permits]![Owner],Null) > Goal: Automatically complete fields if tied to record on the "one side," [quoted text clipped - 5 lines] > "" > at the end of the statement. 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?? > Where are you using this? On a control on a form? In some vba? As the > default property for a control? In a query? [quoted text clipped - 13 lines] > > "" > > at the end of the statement. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.