Welcome to SPN

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

Sign Up Now!

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.
     

Share This Page