Welcome to SPN

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

Sign Up Now!

hide items in drop down menus instead of deleting them

Discussion in 'Information Technology' started by john mcmichael, Nov 3, 2005.

  1. john mcmichael

    john mcmichael
    Expand Collapse
    Guest

    Is it possible to simply hide an item from a combobox/ dropdown list instead
    of deleting it from the list so I can use it later.

    Thank you for help and support
     
  2. Loading...

    Similar Threads Forum Date
    World War 1 To show their contempt for death, some Sikhs had refused to hide in the trenches History of Sikhism May 14, 2014
    Opinion Underneath The Turban: Why Sikhs Do Not Hide Breaking News Aug 23, 2012
    Opinion Underneath the Turban: Why Sikhs Do Not Hide? Breaking News Aug 13, 2012
    UK Hideously diverse Britain: What makes a Sikh join the far right? (Editorial) Breaking News Jun 17, 2010
    Politics Stephen Harper's Canada Chided For Cowardice (Sikh Chic) Breaking News Jun 6, 2010

  3. KARL DEWEY

    KARL DEWEY
    Expand Collapse
    Guest

    Add a field named Active that is a Yes/No field. Use a query as source for
    the combobox with criteria to eliminate any non-active items.

    "john mcmichael" wrote:

    > Is it possible to simply hide an item from a combobox/ dropdown list instead
    > of deleting it from the list so I can use it later.
    >
    > Thank you for help and support
     
  4. xRoachx

    xRoachx
    Expand Collapse
    Guest

    This can be done but it requires that you add a field to the source table and
    edit the row source for the combo box. This is easy to implement. Add a
    column to the source table labeled Active. The values are Y and N for Active
    and Inactive values (or A & I if you prefer). For the values you want
    displayed, place a Y in the Active column and N in the Active column for
    those you don't want displayed.

    In the Row source property of the combo box, add a WHERE statement to the
    SQL. The syntax is WHERE TableName.Active = "Y". For example, say your
    table is named Widgets and you want to display the name of all Widgets in the
    table. Your SQL in the row source property may look like the following:

    SELECT WidgetName FROM Widgets WHERE Active = "Y" ORDER BY WidgetName

    "john mcmichael" wrote:

    > Is it possible to simply hide an item from a combobox/ dropdown list instead
    > of deleting it from the list so I can use it later.
    >
    > Thank you for help and support
     

Share This Page