Automatically update a field when another field is entered.

  • Thread starter Thread starter Donna
  • Start date Start date
D

Donna

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
 
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.
 
Back
Top