Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2002
    Posts
    14

    Unanswered: lookup/updating fields

    I have a table with fields containing only numeric codes. For example, a field named, "ETHNICITY" contains codes 1=English, 2=Hispanic, 3=Asian, 4=Filipino, etc.

    What is the the best way to automatically convert these codes to display only the ethnicity to the end user, such as English, Hispanic, Asian, Filipino, etc.?

  2. #2
    Join Date
    Nov 2001
    Posts
    336
    Hi,

    If you want to display the etnicity in a textbox, then you can use DLookup() function, or have Join of two tables in your form's datasource.

    Another way - is to use combobox to display and update the etnicity. Use combobox wizard, which will help you a lot.

    Igor

Posting Permissions

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