Welcome to SPN

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

Sign Up Now!
  1.   Become a Supporter    ::   Make a Contribution   
    Target (Recurring Monthly): $200 :: Achieved: $98

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
    >
     
Since you're here... we have a small favor to ask...

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     



Share This Page