Welcome to SPN

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

Sign Up Now!

Create a combo box list of Lastname, Firstname from a 2 field source?

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

  1. Mick

    Mick
    Expand Collapse
    Guest

    I'm trying to figure out if there is a way to pull a list of users form
    a table so that rather than have two combo boxes LastName and
    FirstName, coresponding to the Last and First names fields in the user
    table, I have a combo box that is 'LastNameField, FirstNameField'? I
    could setup the source field with 'last, first' but I want to be able
    to access the first and last seperately.

    Thanks for any input.

    Mick
     
  2. Loading...


  3. BruceM

    BruceM
    Expand Collapse
    Guest

    You should indeed store the first name and last name separately. Do get
    them to display together, select the combo box, and click View > Properties.
    Click the Data tab, click Row Source, and click the three dots at the right.
    Add the table. If you are storing the PersonID (the primary key field) add
    that to the query design grid. In the first empty column to its right, put:
    LastFirst: [LastNameField] & ", " & [FirstNameField]
    Use whatever name you want for the new field. Sort ascending, if you wish.
    To store the primary key, set the bound column (Data tab) to 1. Click the
    Format tab; set the column count to 2 and the column widths to 0";1.5".

    "Mick" <MickBurkellc@gmail.com> wrote in message
    news:1149479614.729142.277940@f6g2000cwb.googlegroups.com...
    > I'm trying to figure out if there is a way to pull a list of users form
    > a table so that rather than have two combo boxes LastName and
    > FirstName, coresponding to the Last and First names fields in the user
    > table, I have a combo box that is 'LastNameField, FirstNameField'? I
    > could setup the source field with 'last, first' but I want to be able
    > to access the first and last seperately.
    >
    > Thanks for any input.
    >
    > Mick
    >
     

Share This Page