Welcome to SPN

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

Sign Up Now!
  1. Guest ji, please consider donating today!
      Become a Supporter    ::   Make a Contribution   
    Monthly Recurring Target: $300 :: Achieved: $95

Combo Box

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

Tags:
  1. Adam

    Adam
    Expand Collapse
    Guest

    Help required! I have two tables; tbtask (fields: id, task, techieID) and
    tbtechie (Fields: id, technie, Active - Y/N), utilising a one to many
    relation. The purpose of the Db is to record tasks and assign a technician
    to the task. I have created a form (frmTask) with the task field and a combo
    box for the techie so this can be chosen from a pre-defined list. Great,
    easy. However, what I want to be able to do is filter out techies where the
    Active field state no. I then added to followng to the row source so only
    Active techies would be available in my combo (SELECT tbtechie.id,
    tbtechie.techie FROM tbtechie WHERE (((tbtechie.active)=Yes)); ). This
    appeared to work fine, the combo box only included the techies that where
    active. However for existing records the field was showing blank because it
    wasn't in the list - not really what I had in mind, I needed the combo box to
    be fitlered but the previous select/field value visiable. Too counter this I
    then went to the properties of the combo box I then edited the bound
    properties, this had the desired affect however the combo/field is now
    showing the techieID and not the technie name, not much use to anyone unless
    you refer to people as a number - question is, how to I change the display
    text from the techieId to the techie name?

    sorry if I have posted twice, i had a problem with ie.
     
  2. Loading...


  3. RuralGuy

    RuralGuy
    Expand Collapse
    Guest

    On Mon, 24 Jul 2006 05:36:02 -0700, Adam <adam.dagger@igengroup.co.uk> wrote:

    >Help required! I have two tables; tbtask (fields: id, task, techieID) and
    >tbtechie (Fields: id, technie, Active - Y/N), utilising a one to many
    >relation. The purpose of the Db is to record tasks and assign a technician
    >to the task. I have created a form (frmTask) with the task field and a combo
    >box for the techie so this can be chosen from a pre-defined list. Great,
    >easy. However, what I want to be able to do is filter out techies where the
    >Active field state no. I then added to followng to the row source so only
    >Active techies would be available in my combo (SELECT tbtechie.id,
    >tbtechie.techie FROM tbtechie WHERE (((tbtechie.active)=Yes)); ). This
    >appeared to work fine, the combo box only included the techies that where
    >active. However for existing records the field was showing blank because it
    >wasn't in the list - not really what I had in mind, I needed the combo box to
    >be fitlered but the previous select/field value visiable. Too counter this I
    >then went to the properties of the combo box I then edited the bound
    >properties, this had the desired affect however the combo/field is now
    >showing the techieID and not the technie name, not much use to anyone unless
    >you refer to people as a number - question is, how to I change the display
    >text from the techieId to the techie name?
    >
    >sorry if I have posted twice, i had a problem with ie.
    >

    A ComboBox displays the first visible column of the RowSource when collapsed.
    Try setting the 1st column to 0"; on the Format tab of the ComboBox.
    _______________________________________________
    hth - RuralGuy (RG for short)
    Please post to the NewsGroup so all may benefit.
     
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