Mike & Doris Manning
mikedorism at verizon.net
Tue Sep 20 14:59:23 CDT 2005
I had a similar need. What I did is to use the same recordsource for both drop downs. In the Form Current event of the second form, I set the department dropdown's initial value to the value from the first form and then requeried the second form. Doris Manning mikedorism at verizon.net