title: Can you have an IIF nested within IIF in a Control Source?
body: <p>Is this valid in MS Access VBA:</p>
  
  <pre><code>iif ([company] = "starbucks", "retail", iif ([item] &lt;&gt; "", "DLookup(....)", ""))
  </code></pre>
  
  <p>I'm trying to get something similar to the above work.</p>