Related Control Boxes??

[John]

Hi,
I have a form which I use for inputting/editing data to a simple table. Lets
say I have a table of 10"Categorys" and each category is subdevided into
10 "Item Types". I have set up a table which lists "Categorys" in colum one
with corresponding item types in the second colum.That means I have many
repeated "Category" entries but only one "Item Type" entry opposite per
record. I want to simplyfy the selection of the correct combination of
"Category" and "Item Type".I have set up a form with a list box to select
"Categorys" and a "Combo Box" below it to select "Item Type"

Is this the best combination of controls to use . How do I set up the
controls that they are locked to each other....i.e. selecting Category 1 in
the list box only shows the relivent 10 options in the combo box. Can I do
this or is there a better way? Hope thius makes sense,TIA
John

 

[Stephen Glynn]

There's an explanation of how to do this at

http://www.mvps.org/access/forms/frm0028.htm

Steve

 

[John]

Hi Stephen,
as directed I made a table "Categories" and input the ten "top level"
categories.I then created a combobox on a form which pointed to that table,
and that works fine. When I continue past that stage I get all sorts of
errors. Do I creat a second table linked to the first containing the
subcategories (10 for each top level entry). When i try to use the code it
just locks up. Please explain just a little further, I am new to all this.
John