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

Link a text box based on drop down box with four options MS Word 365 0
Drop down list control value in vba 2
Drop down lists in seperate columns 5
Cross reference drop down not activating 1
Excel 2013: New row added automatically but first 2 columns Drop down lists not available... 0
Dynamic Naming of Form Button 3
Word VBA - Auto Populate Text on Dependent Drop Down Exit 1
drop down list 1

Top