title: Why does Access VBA prompt me for a Macro when I press F5 or Run Sub?
body: <p>I found this question <a href="https://stackoverflow.com/questions/18639581/why-does-excel-vba-prompt-me-for-a-macro-name-when-i-press-run-sub">Why does Excel VBA prompt me for a Macro name when I press Run Sub</a> but the answers don't help me because my sub doesn't have arguments and is not triggered by an event.</p>
  
  <p>I have two subs. One in a Module and one in a Form.</p>
  
  <pre><code>Sub ModuleSub()
      MsgBox ("Hello World")    
  End Sub
  
  
  Sub FormSub()
      MsgBox ("Hello World")
  End Sub
  </code></pre>
  
  <p>The Module Sub DOES RUN when I press F5, but the Form Sub doesn't. It brings up the Macro dialog. What is the problem here?</p>