Filtered Combo Box

[Lisa]

Hello,
I have a database that keeps track of employees in a department and prints
out a directory. These employees can have up to two different positions (a
colateral duty of HR manager for instance). I'm trying to set up a combobox
from the Position table with three fields - PossitionID, Position and Type.
I would like the user to be able to select one of four types, then have the
position list filter from there as there are over 150 different positions. I
thought of putting a listbox in there for the user to select the type first,
but I'm not sure how to go on and filter the combobox from there. Can anyone
help?

Thanks!

 

[Klatuu]

Use two combo boxes. One to select the type and the other to select the
position. Filter the row source query for the second combo based on the
value in the first. Also, in the After Update event of the first combo
(Type), requery the second combo.

 

[Lisa]

Thanks, that's a great idea. I changed my list box that offers the 4
different types to a combo box, then had the after update event requery the
second combo box. Now it's working like a dream!

Lisa