Filtered Combo Box

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Lisa - 27 Dec 2007 18:23 GMT

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!

Reply to this Message

Klatuu - 27 Dec 2007 19:49 GMT

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.

Signature

Dave Hargis, Microsoft Access MVP

> Hello,
> I have a database that keeps track of employees in a department and prints
[quoted text clipped - 8 lines]
>
> Thanks!

Reply to this Message

Lisa - 27 Dec 2007 23:06 GMT

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

> 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
[quoted text clipped - 13 lines]
> >
> > Thanks!

Reply to this Message