Autopopulate question

  • Thread starter Thread starter Antavas
  • Start date Start date
A

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?
 
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?
 
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?
Click to expand...

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