edit one field depending on the contents of another

  • Thread starter Thread starter steve goodrich
  • Start date Start date
S

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