title: How to use a combobox to search for more that one fields in a record ms access?
body: <p>I have a combo box on a form that searches for records on the form. It Works fine However, I wanted to modify the after update event macro so the <code>Where Condition</code> matches 2 fields in the same record where both fields are represented by two column in the same combobox. 
  this is what I have</p>
  
  <pre><code>Where Condition=="[WorkDate] = " &amp; "#" &amp; Format([Screen].[ActiveControl],"mm/dd/yyyy") &amp; "#"
  </code></pre>
  
  <p>I want to modify this combobox to search for both <code>[WorkDate]</code> and another text field called <code>[WorkType]</code>.</p>
  
  <p>I have gone ahead and do a combobox search for the [WorkType] field and got this</p>
  
  <pre><code>Where Condition=="[WorkType] = " &amp; "'" &amp; [Screen].[ActiveControl] &amp; "'
  </code></pre>
  
  <p>any help on how to merge these search criteria would be much appreciated</p>