<div>
just requery the combo whenever db1 finishes<br />
me.cboWhatever.requery<br />

</div>


just requery the combo whenever db1 finishes
me.cboWhatever.requery


<div>
Forced accept.<br />
<br />
Computer101<br />
EE Admin
</div>


<div>
<div class="content wysiwyg-content">
I have 1 database that connects to Peachtree every 30 mins and updates the access tables. &nbsp;I then have database 2 that has link tables back to database 1. &nbsp;Users in DB2 leave forms open all day. &nbsp;When the updates occur every 30 mins, these users don't see changes in the combo boxes until they close and re-open the form. &nbsp;This annoys them! &nbsp;Is there some way that when DB1 finishes it's update that it can tell the combo boxes on the certain forms in DB2 to requery?
</div>
</div>


I have 1 database that connects to Peachtree every 30 mins and updates the access tables.  I then have database 2 that has link tables back to database 1.  Users in DB2 leave forms open all day.  When the updates occur every 30 mins, these users don't see changes in the combo boxes until they close and re-open the form.  This annoys them!  Is there some way that when DB1 finishes it's update that it can tell the combo boxes on the certain forms in DB2 to requery?

Requery combo box in another database

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.