edit one field depending on the contents of another

[steve goodrich]

When I enter "Sheffield" in field1, I would like to automatically populate
field2 with "S Yorks"
The above is just example data, I would like to know how to enter the code
so I can apply it as and when required.
I would also like to populate more than one field at the same time depending
on the contents of another.
any help would be appreciated
Steve Goodrich

 

[Duane Hookom]

It sounds like you want to store values that can be looked up based on
another value. This generally isn't a good idea. If you can explain why you
want to store information that can be referenced in another table, I'm sure
someone can help. It's generally quite easy to display a related value in a
form based on the selection made in a combo box.

You also mentioned "field2". I assume you mean a bound control on a form. An
Access table would not have the functionality of "sticking" a value into
another field in the table.