the list box in ACCESS does not update with the combo box
<p>I have two columns <em>ImportDateOn</em> and <em>InventoryDate</em> in the table <code>[tbl E&amp;O Main]</code>. I create a combo box to navigate <em>ImportDateOn</em> and a list box to display <em>InventoryDate</em>. When I click on my combo box and the list box for <em>InventoryDate</em> should be filtered automatically. I set an <code>AfterUpdate()</code> event on the combo box as following:</p>

<pre><code>Private Sub DateSelector_AfterUpdate()
   Forms![CtrlPanel]!InventoryDateList.Value = Null
   Forms![CtrlPanel].Requery
   Forms![CtrlPanel].Refresh
End Sub
</code></pre>

<p>Then in the datasource for the list box , my code is as following </p>

<pre class="lang-sql prettyprint-override"><code>SELECT [tbl E&amp;O Main].InventoryDate 
FROM [tbl E&amp;O Main] 
WHERE [tbl E&amp;O Main].ImportDateOn=Forms![CtrlPanel]![DateSelector].[value] 
GROUP BY [tbl E&amp;O Main]!InventoryDate; 
</code></pre>

<p>Please advise why the list box doesn't go with the combo box selection. </p>

<p><a href="https://i.stack.imgur.com/rPv4h.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/rPv4h.png" alt="Design View Form Screen Shot"></a></p>