Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

link combo box

Discussion in 'Information Technology' started by Ced, Jul 28, 2006.

Tags:
  1. Ced

    Ced
    Expand Collapse
    Guest

    I have created a form which contains
    districts
    employees
    managers
    questionnaire (5 questions)

    The districts are contained in a combo box (100-800). When I select a
    district, I would like the manager ID to be automatically entered. Example, I
    select district 500 and Manager John Doe is automatically entered.
     
  2. Loading...

    Similar Threads Forum Date
    Eh Janam Tumhare Lekhe... Official Movie Link... Announcements Jun 3, 2015
    Sikhism Complete Shalok Mehala 9 (Link) Videos Apr 22, 2014
    UK British PM orders probe into Thatcher link to Operation Bluestar (UPDATED) Breaking News Jan 14, 2014
    India Gwalior: A Unique Link to India's History Breaking News Nov 16, 2013
    Researchers establish link between racism and stupidity General Sep 28, 2013

  3. Al Camp

    Al Camp
    Expand Collapse
    Guest

    Ced,
    Add the ManagerID to a second column in the combo box. On the AfterUpdate event of the
    combo...
    (use your own control names)
    ManagerID = cboDistrict.Column(1)
    Combo columns are numbered 0, 1, 2, 3, etc... so District in 0 and ManagerID in 1.
    --
    hth
    Al Camp
    Candia Computer Consulting - Candia NH
    http://home.comcast.net/~cccsolutions

    "Ced" <Ced@discussions.microsoft.com> wrote in message
    news:9FAADD4C-D8D4-402F-8769-B52F8E832752@microsoft.com...
    >I have created a form which contains
    > districts
    > employees
    > managers
    > questionnaire (5 questions)
    >
    > The districts are contained in a combo box (100-800). When I select a
    > district, I would like the manager ID to be automatically entered. Example, I
    > select district 500 and Manager John Doe is automatically entered.
     
  4. Ced

    Ced
    Expand Collapse
    Guest

    "Al Camp" wrote:

    > Ced,
    > Add the ManagerID to a second column in the combo box. On the AfterUpdate event of the
    > combo...
    > (use your own control names)
    > ManagerID = cboDistrict.Column(1)
    > Combo columns are numbered 0, 1, 2, 3, etc... so District in 0 and ManagerID in 1.
    > --
    > hth
    > Al Camp
    > Candia Computer Consulting - Candia NH
    > http://home.comcast.net/~cccsolutions
    >
    > "Ced" <Ced@discussions.microsoft.com> wrote in message
    > news:9FAADD4C-D8D4-402F-8769-B52F8E832752@microsoft.com...
    > >I have created a form which contains
    > > districts
    > > employees
    > > managers
    > > questionnaire (5 questions)
    > >
    > > The districts are contained in a combo box (100-800). When I select a
    > > district, I would like the manager ID to be automatically entered. Example, I
    > > select district 500 and Manager John Doe is automatically entered.

    >
    >
    >
     

Share This Page