<div>
This still requires me to click the mouse on another field before it updates the listbox though.
</div>


This still requires me to click the mouse on another field before it updates the listbox though.

<div>
fyed<br />
I actually got it working from the OnDirty event, however your tip about the .text property of the control was useful, so will award you the points
</div>


fyed
I actually got it working from the OnDirty event, however your tip about the .text property of the control was useful, so will award you the points

<div>
<div class="content wysiwyg-content">
I have a field on a form which once updated will cause a Listbox to requery and display new results.<br />
<br />
However, it is a date field, and once they have chosen the date in the date picker in needs to automatically update the listbox, without doing anything else. As far as I can tell, on events can cause this without the user clicking elsewhere on the form. So, immediately upon clicking on a day in the date picker, the listbox needs to requery.<br />
<br />
Is there a way to do this?
</div>
</div>


I have a field on a form which once updated will cause a Listbox to requery and display new results.

However, it is a date field, and once they have chosen the date in the date picker in needs to automatically update the listbox, without doing anything else. As far as I can tell, on events can cause this without the user clicking elsewhere on the form. So, immediately upon clicking on a day in the date picker, the listbox needs to requery.

Is there a way to do this?

Microsoft Access 2013 - Event to automatically update another field

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.