Drop down list seliton filters

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have 2 boxes with drop down list and I want the choice/slection in the
first to filter what apears in the 2nd
Example drop down list box one is a list of states. list box 2 is of all
citys form all states
I want to set it up so only the citys from the state slected in box one
would display in the 2nd drop down box. can someone walk me through this
step by step. I'm new at this and don't know the technical terms. so please
be spicific with instructions.
 
Thanks that hepled some. But I am still having trouble getting it to work in
my aplication. I'm not sure just what I'm doing wrong so I'm starting over
fresh I'm working on making a database to keep track of a toy train
colection. This is what I have
Table "L_types" With "type_id" primaryKey & "type" text
001---Steam Locomotives
002---Passenger Cars
003---Rolling Stock Cars

Table "L_subtypes" With "subtype_id" primaryKey & "subtype" text & "type_id"
number
01--- 4/6/2 Pacific ---001
02--- 4/6/0 General ---001
03--- Hopper Car ---003
04--- Box Car ---003
05--- Coach Car ---002
06--- Pulman Car ---002

Table "Trains" With
"train_id" primarykey &
"Train_name" text &
"model no" text &
"Type" text with the lookup Wizard pointed to "L_types/type" &
"subtype" text

this is where I'm lost where do I go from hear to get the "subtype" drop
down list in the "Trains" table to only display the subtype corosponding to
the Type that was chosen from the "Type" drop down list. Is this done at the
Table or the Forms

thanks for your help
 
First, I recommend that you not use a lookup field in your table. It will
only cause great confusion later on. See this article for more info:
http://www.mvps.org/access/lookupfields.htm

Second, the code at The ACCESS Web is for use in a form. You cannot use such
code in tables. Create a form that has the combo boxes that you want to use.
Then you can apply the code to filter the second combo box based on the
selection in the first. You cannot do such filtering directly in a table
with lookup fields.
--

Ken Snell
<MS ACCESS MVP>
 
First I want to say thanks for all the help you have given so far.
2nd I must be doing something wrong because I'm still unable to get it to
work for me. Is their a sample db or template (which has this type fuction
in it) that I could download or view so that i can compair it to mine to help
me figure out what I am doing wrong?
 
Back
Top