 <p>I've never done this myself, so I kind of wanted to try it.</p> <h2>Everything we need:</h2> <p>2 Forms, 1 query, and 1 (technically 3) line(s) of VBA.</p> <p>The "search"/parent form. I created a blank form and called it <strong>Form4</strong>. I added 2 textboxes, 2 labels, and a button to it.</p> <ol> <li>txtSearch1 - Textbox 1</li> <li>txtSearch2 - Textbox 2</li> </ol> <p>I then created a query that filters records by what's in these 2 textboxes. I don't have the same table/schema you did, so bare with me on the names/data types.</p> <p>My setup: </p> <ol> <li>Table: tblEmployee</li> <li>Fields: ID, EmployeeNumber, Names</li> <li>Fields I am filtering: ID, EmployeeNumber</li> </ol> <h2>The Query: (mainly to show how we are filtering)</h2> <pre><code>SELECT tbl_Employee.ID, tbl_Employee.EmployeeNumber, tbl_Employee.FirstName, tbl_Employee.LastName FROM tbl_Employee WHERE (((tbl_Employee.ID) Like "*" &amp; [Forms]![Form4]![txtSearch2] &amp; "*") AND ((tbl_Employee.EmployeeNumber) Like "*" &amp; [Forms]![Form4]![txtSearch1] &amp; "*")); </code></pre> <p>The searches are flexible, as they use wildcards. You can remove these, but I figured the more information the better.</p> <p>So, we now have a Form with 2 textboxes that we use to narrow down our query results.</p> <p>Next step, create another form to be inserted into <strong>Form4</strong> to view our search results.</p> <p>Create a <em>blank</em> Form (I named mine <strong>Form5,</strong> hooray). Right click in the top left corner of the Form, and select "Properties".</p> <p>On the <em>Format</em> tab: <strong>Default View</strong>: Datasheet</p> <p>On the <em>Data</em> tab: <strong>Record Source</strong>: Query5 (or your query name) <strong>Recordset Type</strong>: Dynaset</p> <p>Go back to the form. In design view, in the Access Tool bar at the top, and to the right "Add Existing fields". Add whichever fields you want from your query.</p> <p>Close <strong>Form5</strong>.</p> <p>Open <strong>Form4</strong> in Design View. Drag <strong>Form5</strong> onto <strong>Form4</strong>. Save it.</p> <p>On Form4, right click on the Button we added, or add it if you have not. Go to Properties, Event -> OnClick -> (click the three little <code>...</code>). Double click on <em>Code Builder</em>. Type in <code>Me.Form5.Requery</code>. (or <code>Me.YourFormNameHere.Requery</code>).</p> <p>Run Form4 and test your filtering capabilities.</p>