Filtered Drop Down Menu Based on Previous Drop Down Selection



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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question