Populate a second combo box menu when choosing criteria in the first combo box(State/City example)

Can somebody give a very simple (3 States  3 Cities) example of how in Access I can make a form that after choosing a State from a combo box (vlook up from State table)   will populate the second combo box with predetermined list of cities  for the State selected?


Thanks in advance for any input.
LVL 1
Exl04Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Rey Obrero (Capricorn1)Connect With a Mentor Commented:
see this sample db


2Combobox.mdb
0
 
Exl04Author Commented:
capricorn1,
Thanks for the sample.
I took the State/City sample as an analogy for my Db because I knew it will be the best way to explain what I needed it. But,
How can I accomplish the same result if I have separate tables for State and Cities?

This is what Im doing; Im creating a very simple database to collect data in a manufacturing process. The unit been build goes trough 3 inspection Station and I need a form to record the particular issues in each stations, this Issues are not the same in each Station. So I got a table for Station 1, 2, and 3, particular Issues , how can I created a form that will have a combo box that will choose the Station number and then after choosing the Station number the next combo box (Issues) drop down menu will populate according to the Station been chosen in Stations combo box?

I need to write this to a new table where I will have al the Stations data to make reports.

I have attached a sample to help understand what Im trying to do

Thanks gain fro the help.

Example.mdb
0
 
dannywarehamCommented:
http://www.mvps.org/access/forms/frm0028.htm

Have your values in two tables (related) and you can use this as an example.
0
What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

 
Exl04Author Commented:

Dannywareham, thanks for replaying
I must be doing something wrong, or I havent explained correctly what Im trying to accomplish;
 The tables Issues are tables that will be maintain in a weekly bases, Issues are going to be added and subtracted every week, so I need these tables as they are.
 I tried to use the code sample on the link you provided and what the first combo box gives me is the fields names of the table  Stations. Can you apply on the samples to the Example data base I posted?
I need when I choose Station number in combo box 1 populate combox2 with the Issues of station selected in combox1

Thanks
0
 
Exl04Author Commented:
Can some one tell me if I'm using the right table design to use these tables in a combo box.?

Thanks!
0
 
Exl04Author Commented:
capricorn1:
   Thanks for the sample
dannywareham:
   Thanks for the link

I will adapt capricorn1 method

IgnBan
0
 
Exl04Author Commented:
Thanks for let me learn from you!

IgnBan
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.