Excel - Conditional Lists?

[DummyForAccess]

I am working on a form. I am using drop-down lists for folks to choose different answers. Is it possible to have a dropdown reference a previous drop-down and base the options on the previous drop-down? For example, if they choose a department of registration, the next drop down of job titles would reference a certain region where I have registration job titles... Hope this makes sense..

 

[SkipVought]

Hi,

Sure. Use a parameter query to return the subset of data related to the first selection.

faq68-5829

Skip,

_[red][/red]