Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Apr 2003
    Calgary, Alberta
    Thanked 0 Times in 0 Posts

    Lookup table within Drop Down Menu (Access 2000)

    I have a drop down menu which gets is data from a query. One of the columns contain a single letter stating the status of that specific product in the order. (whether it is an Backorder item, damaged item) etc. I would like to have the meaning of the letter, instead of the letter itself in the dropdown menu,. So B would be Backorder Item, D is Damaged Item, and so on.

    How can I accomplish this?


  2. #2
    Super Moderator
    Join Date
    Jun 2002
    Mt Macedon, Victoria, Australia
    Thanked 45 Times in 44 Posts

    Re: Lookup table within Drop Down Menu (Access 200

    I assume that by drop down menu you mean a combo box.

    Unless you already have it stored somewhere, you need a table that holds the explanations of these codes. So you could create a table tblstatus with two fields such as statuscode, and statusdescription , and pairs of values such as B, Backorder etc.

    Join this table to the query that provides the data for the dropdowns, then add statusdescription as the 2nd column in the data for the dropdown, and set the width of the first column to 0. The combo will then display the descriptions, but store the status code.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts