Requery combo box in another database

Posted on 2007-10-18
Last Modified: 2013-11-28
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?
Question by:etechit
    LVL 19

    Expert Comment

    just requery the combo whenever db1 finishes
    LVL 19

    Accepted Solution

    or you can use the form's timer event to refresh the combo using the code above every 5 minutes or whatever interval you want.
    LVL 19

    Expert Comment

    LVL 1

    Expert Comment

    Forced accept.

    EE Admin

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Join & Write a Comment

    Most if not all databases provide tools to filter data; even simple mail-merge programs might offer basic filtering capabilities. This is so important that, although Access has many built-in features to help the user in this task, developers often n…
    Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
    Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
    In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

    745 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now