title: Access how to show record count of a table on a form
body: <p>I want to show a variable value (record count of a table) on an Access form. I tried with a textbox by defining its control source with the following and many other internal functions but all returned only errors. Anyone can help? Thanks</p>
  
  <pre><code>select count(*) from TableName
  </code></pre>