Welcome to SPN

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

Sign Up Now!

Pull user # from a combo box and pull the related user first and last name as well?

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

  1. Mick

    Mick
    Expand Collapse
    Guest

    I'm trying to figure out how to create a form where I can pull the user
    number from anotehr table wiht a combo box (this part I've got figured
    out), and when I select the user number that I also get the user name
    (from the same table that I have pulled the User #) entered into
    another field in the form. I know theres a simple way I can do this,
    and think I have before, but I use access so rarely that I forget most
    of the tricks by the next time I use it...

    Thaks for any input...

    Mick
     
  2. Loading...

    Similar Threads Forum Date
    oh well, may as well pull an all nighter Blogs Oct 16, 2015
    Controversial British people pull some extreme disrespect and Beadbi near Southall Gurdwara Hard Talk May 9, 2012
    Inspirational Bystanders Pull Utah Man Out from Under His Burning Motorcycle Videos Sep 15, 2011
    SRCC SIFE Students Lift Rickshaw Pullers from Abyss Inspirational Stories Jun 25, 2011
    India Bill & Melinda Gates Foundation to pulls out of India Breaking News Aug 2, 2009

  3. Ofer Cohen

    Ofer Cohen
    Expand Collapse
    Guest

    RE: Pull user # from a combo box and pull the related user first and l

    Hi Mick
    The combo box need to include both fields, Id and name

    Select [User #] , [User Name] From TableName

    On the after update event of the combo, after the Id is selected, write the
    code that will assign the value to the User name text box

    Me.[User Name] = Me.[Combo Name].Column(1)

    Or, in the text box control name you can write
    =[Combo Name].Column(1)

    Note: the column number start with 0

    --
    Good Luck
    BS"D


    "Mick" wrote:

    > I'm trying to figure out how to create a form where I can pull the user
    > number from anotehr table wiht a combo box (this part I've got figured
    > out), and when I select the user number that I also get the user name
    > (from the same table that I have pulled the User #) entered into
    > another field in the form. I know theres a simple way I can do this,
    > and think I have before, but I use access so rarely that I forget most
    > of the tricks by the next time I use it...
    >
    > Thaks for any input...
    >
    > Mick
    >
    >
     

Share This Page