Combo Box Problems

I need to set up a combo box that will pull up options based on a list of
values.

if material is CPVC then list all sizes that cvpc can be but do not display
other material sizes. like wise for steel, etc. all materials will have
sizes but not all materials will have all sizes. but I have a list of
materials and a list of sizes, my parts list will pull from the materials
sheet but it will not pull sizes from the sizes sheet based on the material
type.

This is the sql for the row source I am using for geting this is from the
other table is as follows - Any Ideas where I am going wrong?


SELECT Mastersizelist.SIZE FROM MASTERSIZELIST WHERE
(((MASTERSIZELIST.SIZE)=MASTERLIST.MATERIAL)) ORDER BY Mastersizelist.SIZE;

Search on Cascading Combos.
--
KARL DEWEY
Build a little - Test a little


"Prescott" wrote:

I need to set up a combo box that will pull up options based on a list of
values.

if material is CPVC then list all sizes that cvpc can be but do not display
other material sizes. like wise for steel, etc. all materials will have
sizes but not all materials will have all sizes. but I have a list of
materials and a list of sizes, my parts list will pull from the materials
sheet but it will not pull sizes from the sizes sheet based on the material
type.

This is the sql for the row source I am using for geting this is from the
other table is as follows - Any Ideas where I am going wrong?


SELECT Mastersizelist.SIZE FROM MASTERSIZELIST WHERE
(((MASTERSIZELIST.SIZE)=MASTERLIST.MATERIAL)) ORDER BY Mastersizelist.SIZE;