title: Access - Drop Down List Open Form
body: <p>Please be gentle, i'm new to access but I'm trying to create a down down list that opens forms. I've done a fair bit of Google searches and not really found anything.</p>
  
  <p>On my ComboBox on both "After Update" and "On Change" I have tried the below code.... Both with and without data in my drop down list.</p>
  
  <pre><code>Private Sub Combo1_AfterUpdate()
  
      Select Case Combo1.Value
  
          Case "Menu1"
              DoCmd.OpenForm "Form1"
          Case "Menu2"
              DoCmd.OpenForm "Form2"
          Case "Menu3"
              DoCmd.OpenForm "Form3"
  End Sub
  </code></pre>
  
  <p>I have also tried;</p>
  
  <pre><code>DoCmd.OpenForm Combo1.Value
  </code></pre>
  
  <p>and adding my form names in the ComboBox but that doesn't work either.</p>
  
  <p>Thanks in Advance.</p>
  
  <p>.Lee</p>