Requery combo box in another database
Posted on 2007-10-18
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?