Automatically update a field when another field is entered.

[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

 

[Mike Painter]

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.