Results 1 to 3 of 3
  1. #1

    Combo Box in form not showing update

    I have an Access 97 database that tracks job applications. On the form for Job Details I have two combo boxes. The first one is for the Agency and the second is for the Agent. The list for the Agents has for its row source a selection query based on the agency entered in the Agency combo box so that it only presents agents belonging to that agency. This works fine for data entry thanks to help in a recent thread that I followed, explaining how to do this.
    My problem now is that when a record is subsequently displayed using this form, only one record displays the agent

  2. #2
    Gold Lounger
    Join Date
    Jun 2001
    Crystal Beach, FL, Florida, USA
    Thanked 41 Times in 40 Posts

    Re: Combo Box in form not showing update

    You need to force a requery of that Agent combo box. You should put cboAgent.requery in your form's Current event (and also in AfterUpdate event of cboAgency).
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  3. #3

    Re: Combo Box in form not showing update

    Thanks Mark - that does just what I want

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts