edit one field depending on the contents of another

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
 
G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

format question 5
query just the first initial of a name 4
Count null fields 4
Automatically a checkbox based on another field? 1
How do i input a date based on value in an another access field 2
updated field 3
limit the choice of a combo box based on the choice of another 3
Set One Field based On Another Field 2

Top