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

    Lookup table for results (Access 2000)

    I have a subform which displays the results of a query. The query is used to display the products in the invoice. Each product has a text field which displays the status of the product. That value is stored as a single character. I would like to have that single character replaced with a string which says what the status actaually is. For exmple, I = Order, B = On Backorder. I am not sure how to replace the letter to the value that I want in the results of the query. I guess I am trying to get a lookup table

    Thanks

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Lookup table for results (Access 2000)

    Create a new table with two fields: a 1-character text field named Status (the primary key of the table) and another text field named StatusDescription (length depends on what you need).
    Fill the table with the status codes and their descriptions.

    In the subform, right-click the text box that displays the status and convert it to a combo box.
    In the Properties window, set the following properties:

    In the Data tab:
    Row Source: name of the table you just created
    Limit to List: Yes

    In the Format tab:
    Column Count: 2
    Column Widths: 0";2"

  3. #3
    3 Star Lounger
    Join Date
    Apr 2003
    Location
    Calgary, Alberta
    Posts
    327
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Lookup table for results (Access 2000)

    Cool [img]/forums/images/smilies/smile.gif[/img] I was close. I was trying to get the results from a query that accessed my lookup table, instead fo going directly to the lookup table

    Thanks again

Posting Permissions

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