title: Create a custom query form (MS Access)
body: <p>I have created an MS Access Form, an MS Access Query and a table depend on an excel file.
  The form is named <code>CheckForm</code> and consists of a textfield for serialno, a search button (which has a makro to run a query) and a few fields with information, that should be filled by the query:
  <a href="https://i.stack.imgur.com/olGRQ.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/olGRQ.png" alt="MS Access Form"></a></p>
  
  <p>The query is named <code>assets_ALT Abfrage - Serialno</code> and looks as follows:</p>
  
  <pre><code>SELECT Assets_ALT.STREETADDRESS, Assets_ALT.FLOOR, Assets_ALT.ROOM, Assets_ALT.DEPARTMENT, Assets_ALT.ITC_NAME, Assets_ALT.ASSET_USER_NAME, Assets_ALT.PERSONID, Assets_ALT.COMPUTER_NAME, Assets_ALT.CATEGORY, Assets_ALT.MANUFACTURER, Assets_ALT.PRODUCT, Assets_ALT.MODELL, Assets_ALT.SERIALNUM, Assets_ALT.MAC_ADDRESS
  FROM Assets_ALT
  WHERE (((Assets_ALT.SERIALNUM)=[Formulare]![CheckForm]![SearchSerialNo]));
  </code></pre>
  
  <p>The table with information, on which the query is built looks like this:
  <a href="https://i.stack.imgur.com/o5pWI.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/o5pWI.png" alt="MS Access Table"></a></p>
  
  <p>When entering a serial no into the form like <code>F7D5H92</code>, clicking the <code>Suchen</code>-Button, the <strong>form should be filled with the data from the query.</strong></p>
  
  <p><em>But it does not, instead the query is being opened (and showing no result):</em>
  <a href="https://i.stack.imgur.com/C15Pe.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/C15Pe.png" alt="Result"></a></p>