Professional Web Applications Themes

Access auto fill/populate field with list of different values - Microsoft Access

I am creating a database with the following fields in the table ID - ID Number for person LAB - Lab Name LABDT - Lab date LABVAL - Value of the lab I have a list of about 15 different labs for each person. When the user goes to enter data on the form, I want the form to look something like the following LAB LABDT LABVAL Hemo Plate NA K Which will make the data in the tables look like ID LAB LABDT LABVAL 1 Hemo 1/1/2001 1.0 1 Plate 2/1/1/2001 5.0 1 NA 1/5/2001 10.1 1 K 2/2/2001 ...

  1. #1

    Default Access auto fill/populate field with list of different values

    I am creating a database with the following fields in the table

    ID - ID Number for person
    LAB - Lab Name
    LABDT - Lab date
    LABVAL - Value of the lab

    I have a list of about 15 different labs for each person. When the
    user goes to enter data on the form, I want the form to look something
    like the following

    LAB LABDT LABVAL

    Hemo
    Plate
    NA
    K


    Which will make the data in the tables look like

    ID LAB LABDT LABVAL
    1 Hemo 1/1/2001 1.0
    1 Plate 2/1/1/2001 5.0
    1 NA 1/5/2001 10.1
    1 K 2/2/2001 5.4


    I want the Lab field to be specified by the form so that the user only
    has to enter the labdt and labval.

    How do I do this in access 2000?

    Thanks
    Michael Guest

  2. #2

    Default Re: Access auto fill/populate field with list of different values

    On 15 Jul 2003 08:42:17 -0700, [email]lumiya[/email] (Michael) wrote:
    >I am creating a database with the following fields in the table
    >
    >ID - ID Number for person
    >LAB - Lab Name
    >LABDT - Lab date
    >LABVAL - Value of the lab
    >
    >I have a list of about 15 different labs for each person.
    Does the list vary from person to person, or is it standard?
    >...
    >
    >I want the Lab field to be specified by the form so that the user only
    >has to enter the labdt and labval.
    You could base the Subform on a Query joining the list of standard
    labs (or a Query selecting that patient's labs) to the Results table
    by the test ID using a Left Join - "show all records in StandardLabs
    and matching records in Results". Be sure to include the LabID field
    from the Results table in the query. Now if you enter the labdt and
    labval, Access will fill in the LabID.

    John W. Vinson[MVP]
    Come for live chats every Tuesday and Thursday
    [url]http://go.compuserve.com/msdevapps?loc=us&access=public[/url]
    John Vinson Guest

Similar Threads

  1. Forms: Text field - auto fill another field?
    By LDVDG@adobeforums.com in forum Adobe Acrobat Macintosh
    Replies: 3
    Last Post: May 18th, 05:35 PM
  2. Replies: 0
    Last Post: September 22nd, 10:26 PM
  3. How to populate drop down list from one field withdelimiters
    By Anj01 in forum Macromedia ColdFusion
    Replies: 4
    Last Post: June 22nd, 07:47 PM
  4. Best way to access field values using ADO.
    By John Beschler in forum ASP Database
    Replies: 10
    Last Post: December 9th, 04:31 PM
  5. Auto populate a field in a form from another table
    By Sandra Daigle in forum Microsoft Access
    Replies: 0
    Last Post: August 1st, 01:08 AM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139