form question with table question

  • Thread starter Thread starter ryan.fitzpatrick3
  • Start date Start date
R

ryan.fitzpatrick3

I made a form to look up 3 table fields. What I have is a table with a
filter section of items;

field 1 is GROUP
field 2 is CATEGORY
field 3 is CLASS


it would lay out like this

GROUP CATEGORY CLASS
1 0 1
1 0 2
1 1 1
1 1 2
1 2 0
1 3 0
1 3 1
2 0 0
2 0 1
ETC


In the table It looks like this, category and class are sub filters of
the field before it, and I have 3600 total selections. Now I made a
form with 3 combo boxes where the 1st gets GROUP, 2nd gets CATEGORY,
and 3rd gets CLASS.

Now in my query I linked the GROUP to the group combobox selection,
CATEGORY to the category combobox and CLASS to the class combobox. and
the rowsource reflects the table that has all 3600 selections.

Is there away to make category combobox only select records that match
up with group? So if I select 1 for group then only 0,1,2,3 are the
only selections for category and therefore depending on the selection,
lets say category I chose 1, the class would have the options of only
1, 2. I've done this in the past when I had tables that were subtables
of each other but not from 1 table with 3 fields. Thanks.

Ryan
 
If I understand you correctly, try downloading from Microsoft site
FrmSampl.mdb.

There are many good examples you can adopt.
 
Back
Top