Filtered Drop Down Menu Based on Previous Drop Down Selection

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
 

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

Similar Threads

drop down not allowing selection 6
Adaptive drop down menus which filter the next possible selection 1
Enable 2 fields based on the drop down selection of another field 2
Label based on drop-down box selection 3
Contents of one drop down list based on the contents of another li 2
Synchronized Combo Box Not Working 3
Filtered drop down list 2
Additional option for drop-down menu 1

Top