title: How do I search forms in Access using values from another table that is being referenced?
body: <p>The management staff in my department has been asked to record any and all errors committed by our team. I created a database to store them and a simple form for the management team to use to record each error. Several fields are referencing other tables such as Staff, issue category, root cause, etc...
  We need to be able to search the forms for specific records to either update or review, and I have found the best way for us to search is by filtering the forms based on the individual who committed the error. Here is the code that I am using for the search button:</p>
  <p>Private Sub SearchRecord_Click()
  Dim Search As String
  Search = InputBox(&quot;Please enter who committed the error&quot;, &quot;Name&quot;, ErrorMadeBy)
  If Search = &quot;&quot; Then Exit Sub
  Me.Filter = &quot;ErrorMadeBy = &quot;&quot;&quot;<em>&quot; &amp; Search &amp; &quot;</em>&quot;&quot;
  Me.FilterOn = True
  End Sub</p>
  <p>The filter works great, but instead of filling out the name, you have to use the ID number in the Staff table when filling out the Input Box. I'd like to be able to input the name (or part of the name) instead of having to have everyone memorize the ID numbers from the staff table.</p>