Link to home
Start Free TrialLog in
Avatar of Exl04
Exl04

asked on

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.
ASKER CERTIFIED SOLUTION
Avatar of Rey Obrero (Capricorn1)
Rey Obrero (Capricorn1)
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Exl04
Exl04

ASKER

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
http://www.mvps.org/access/forms/frm0028.htm

Have your values in two tables (related) and you can use this as an example.
Avatar of Exl04

ASKER


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
Avatar of Exl04

ASKER

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

Thanks!
Avatar of Exl04

ASKER

capricorn1:
   Thanks for the sample
dannywareham:
   Thanks for the link

I will adapt capricorn1 method

IgnBan
Avatar of Exl04

ASKER

Thanks for let me learn from you!

IgnBan