Autopopulate question

[Antavas]

I have a data table with a list of states and the regions they fall into
(Southeast, Northeast, etc)

On my form I need it to populate the correct region when I choose a state
from a dropdown box. How do I go about this?

 

[Antavas]

The state box has already been created in the form. I'm having to add in the
Region box on its own. How can I link them when I choose a state from the
drop down so the correct region will populate?

 

[John W. Vinson/MVP]

The state box has already been created in the form. I'm having to add in the
Region box on its own. How can I link them when I choose a state from the
drop down so the correct region will populate?

If you're trying to store the Region into a table other than the
States table... *don't*. It's redundant, unnecessary, and even
dangerous (you might later decide to split a region into two, and you
would then have obsolete data in your table). Just store the state and
use a Query or the combo column property as suggested to *display* the
region.