title: Use an Access Forms Unbound text box as a Field filter in a table
body: <h1>Access 2013 - Reference an Unbound text box on a Form</h1>
  
  <p>I am currently trying to use an unbound text box <code>[Text161]</code> on a Form name <code>[DCM_Gap_Servers]</code> to sort information through a table. I want the query that I created to be able to take the users input from <code>[DCM_Gap_Servers]![Text161]</code> as the field that is being sorted from the table names 'Server'. </p>
  
  <p>This is the SQL I am using right now in the query:     </p>
  
  <pre><code>SELECT * FROM Servers WHERE "Forms![DCM_Gap_Servers]![Text161]" IS NULL
  </code></pre>
  
  <p>** I have already Tried:</p>
  
  <pre><code>"Forms![DCM_Gap_Servers]![Text161]" ; (Forms![DCM_Gap_Servers]![Text161]); Forms.[DCM_Gap_Servers]![Text161]     
  </code></pre>
  
  <p>This will work at any time if I replace the Text Box reference with the actual Field name I am using, but since there are hundreds of combinations of fields, I need the reference to work.</p>
  
  <p>I have looked all over, and I can't seem to find the correct answer. I am willing to do it in VBA if needed, whatever it takes to get the filtering done correctly.</p>
  
  <p>Thank You.</p>