title: Choose ImageField.Picture based on the Value in Another Field
body: <p>I am new to Access but, thanks to this great forum, I have learned a lot in the past few weeks.  </p>
  
  <p>I am trying to make an image control to display one of three arrow images depending on a value of "1,2 or 3" in another field.  The arrows represent market trends for the current record.  The arrows are Up (value = 1, image="cmdTrendUp"), Sideways (value = 2, image="cmdTrendNeutral") and Down (value = 3, image="cmdTrendDown").  (The images are labeled "cmd" because the same images are shared with buttons on another form.)</p>
  
  <p>I used nested IIF functions as an expression.  The image for a value of "1" shows up as expected.  However when I cycle through the records only the Green/Up arrow is displayed.  Can you help me determine what is wrong?</p>
  
  <pre><code>=IIf([DEMO_UrlMsaCountyCAmq_MuniList]![TrendarrowValue]=1,[cmdTrendUp],IIf([DEMO_UrlMsaCountyCAmq_MuniList]![TrendarrowValue]=2,[cmdTrendNeutral],IIf([DEMO_UrlMsaCountyCAmq_MuniList]![TrendarrowValue]=3,[cmdTrendDown],[Anicon Orb.png])))
  </code></pre>