title: MS Access, use query name as field default value
body: <p>My department uses a software tool that can use a custom component library sourced from Tables or Queries in an MS Access database.</p>
  
  <pre><code>Table: Components
    ID:   AutoNumber
    Type: String
    Mfg:  String
    P/N:  String
    ...
  
  Query: Resistors
    SELECT Components.*
    FROM Components
    WHERE Components.Type = "Resistors"
  
  Query: Capacitors
    SELECT Components.*
    FROM Components
    WHERE Components.Type = "Capacitors"
  </code></pre>
  
  <p>These queries work fine for SELECT. But when users add a row to the query, how can I ensure the correct value is saved to the Type field?</p>