Welcome to SPN

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

Sign Up Now!

Completing fields based on data in another field

Discussion in 'Information Technology' started by Linda, Nov 16, 2005.

  1. Linda

    Linda
    Expand Collapse
    Guest

    Hi All,

    I have a table that includes Employee name, Employee badge, and Employee
    crew code. I would like to select or type the employee badge in a form field
    and have the other 2 fields completed automatically in the form, based on the
    badge that is entered.

    It seems I must make the fields combo-boxes and have the source listed as
    the table. However, each field then returns only the first column of data in
    the table and must be selected seperately.

    I have looked at some Northwind samples, but I do not understand how to do
    this.

    If you can help, it would be greatly appreciated!

    Thanks
    --
    Linda
     
  2. Loading...

    Similar Threads Forum Date
    Gurus Guru Gobind Singh Completing Guru Nanak’s Revolution History of Sikhism Jan 18, 2010
    US Defense Department Hiring Resident Aliens in Medical and Language Fields Business, Lifestyle & Leisure Dec 6, 2008
    Sikh News Women more vulnerable to cancer in Punjab's cotton fields (New Kerala) Breaking News Apr 1, 2008
    Sikh News Women more vulnerable to cancer in Punjab's cotton fields (Calcutta News) Breaking News Apr 1, 2008
    Sikh News Punjab's killing fields (The Times of India) Breaking News Feb 24, 2008

  3. Arvin Meyer [MVP]

    Arvin Meyer [MVP]
    Expand Collapse
    Guest

    You can select multiple fields in a combo box. Set their widths like:

    0"; 1.5"; 2"; 0"; 0"

    Which would set the widths of 5 fields, 2 of which are visible when the box
    is dropped down. The column index is zero based. To display the contents of
    the fourth column in a textbox, set its controlsource to:

    Forms!FormName!ComboName.Column(3)
    --
    Arvin Meyer, MCP, MVP
    Microsoft Access
    Free Access downloads
    http://www.datastrat.com
    http://www.mvps.org/access


    "Linda" wrote:

    > Hi All,
    >
    > I have a table that includes Employee name, Employee badge, and Employee
    > crew code. I would like to select or type the employee badge in a form field
    > and have the other 2 fields completed automatically in the form, based on the
    > badge that is entered.
    >
    > It seems I must make the fields combo-boxes and have the source listed as
    > the table. However, each field then returns only the first column of data in
    > the table and must be selected seperately.
    >
    > I have looked at some Northwind samples, but I do not understand how to do
    > this.
    >
    > If you can help, it would be greatly appreciated!
    >
    > Thanks
    > --
    > Linda
    >
     

Share This Page