Filtered Drop Down Menu Based on Previous Drop Down Selection

  • Thread starter Thread starter Korski
  • Start date Start date
K

Korski

I have a two drop down menus on a data entry form. The first is a material
manufacturer the second is a formulation drop down. I have a reference
table with all material manufacturers and their formulations. After the
operator selects the material manufacturer in the first drop down, I want
the second drop down to limit the formulations to just the ones available
from this particular manufacturer.
I was able to do this with a query by putting the rowsource for the
drop down as a query that has a criteria value based on the first drop down,
however when running the form, it will not allow you to go back and change
the material manufacturer. It continues to limit the selections of the
second drop down based on your very first input in the top drop down. Is
there a way to make this work after updating the first drop down ?

Thanks, Adam
 
Back
Top