Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2003
    Posts
    11

    Unanswered: Updating with List/Combo Boxes

    I have a form with multiple tabbed pages that draws information from 2 tables. I have a combo box that assigns a value to the ORIGINATOR field. When I pick the ORIGINATOR from the combo box, I want it to automatically update the values of two other controls on the form, REGION and OFFICE, and store these values in a table. There are two tables involved in this:

    1. CCBPIPE is where I want to store all of this information
    2. Branch_Table has only ORIGINATOR, REGION, and OFFICE as fields, so it should be used for looking up the REGION and OFFICE based on the ORIGINATOR that is chosen.

    How might I go about this?

  2. #2
    Join Date
    Nov 2002
    Location
    Hamilton,Ontario
    Posts
    132

    Re: Updating with List/Combo Boxes

    post ur source code or project and that will make it clear
    but the way i see , u should use combobox_afterupdate Event
    and then update the field accordingly.

    but posting ur project would help .

  3. #3
    Join Date
    Jun 2003
    Posts
    11
    Here is the code for the combo box:

    Row Source:
    SELECT DISTINCT CCBPIPE.ORIGINATOR FROM CCBPIPE ORDER BY CCBPIPE.ORIGINATOR;

    On Click:
    Private Sub OrigDD_Click()
    Me.Combo346.Requery
    End Sub

    Is that helpful?

Posting Permissions

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