Professional Web Applications Themes

Automatically update a field when another field is entered. - Microsoft Access

I am trying to create a field in a form that will be automatically populated when another field is entered. I have facility names with related ID numbers. This Id Number is hidden on the form. When a user enters a facility (from a dropdown list), I would like this field to be automatically populated (there is, of course, a unique ID field populated in the actual table). Please help. Thanks, Donna...

  1. #1

    Default Automatically update a field when another field is entered.

    I am trying to create a field in a form that will be
    automatically populated when another field is entered. I
    have facility names with related ID numbers. This Id
    Number is hidden on the form. When a user enters a
    facility (from a dropdown list), I would like this field
    to be automatically populated (there is, of course, a
    unique ID field populated in the actual table). Please
    help.

    Thanks,
    Donna
    Donna Guest

  2. #2

    Default Re: Automatically update a field when another field is entered.

    It is indeed confusing. The way I read it, simply setting the comboboxes
    source to the ID field will do what you want.

    If other fields are involved then there should be a join between your main
    table and the facility names table. The main table would only contain the
    Facility ID and the join would allow what you seem to want.

    "Bish" <mike.bishopbtinternet.com> wrote in message
    news:01de01c35798$70f166a0$a501280aphx.gbl...
    > You submission is a little vague, however you can use the
    > AfterUpdate event of the combobox to trigger a process
    > that will populate your second field. How you determine
    > what value is entered into the second field is down to you.
    >
    > >-----Original Message-----
    > >I am trying to create a field in a form that will be
    > >automatically populated when another field is entered. I
    > >have facility names with related ID numbers. This Id
    > >Number is hidden on the form. When a user enters a
    > >facility (from a dropdown list), I would like this field
    > >to be automatically populated (there is, of course, a
    > >unique ID field populated in the actual table). Please
    > >help.
    > >
    > >Thanks,
    > >Donna
    > >.
    > >

    Mike Painter Guest

Similar Threads

  1. Question Automatically generate user initials in Acrobat text field?
    By Sylas in forum Brainstorming Area
    Replies: 0
    Last Post: April 19th, 07:59 PM
  2. SOS! To validate if form field entered by user is validnumber (not a negative value)
    By design in progress in forum Coldfusion Database Access
    Replies: 1
    Last Post: May 24th, 04:02 PM
  3. Validate if form field entered by user is valid number(not a negative value)
    By design in progress in forum Coldfusion Database Access
    Replies: 2
    Last Post: May 24th, 07:06 AM
  4. How automatically enter the new month in repeating field ?
    By Hubert Van Bel in forum FileMaker
    Replies: 0
    Last Post: October 14th, 09:14 AM
  5. Replies: 0
    Last Post: September 2nd, 01:39 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