I have a list of departments in the first list box, but depending on which
departement the user selects, the second list box will offer a different
selection of sub departments.

EG
Schools , then the lsecond list of all schools would be displayed
but if
Education Management had been selected, then a different second list would
be displayed to choose from

I currently do this in Excel by naming the ranges and using the =indirect in
the data validation.  Can something like this be done in access

Any help on this would be extremely helpful
Thanks