combobox data recognition?

[Kelly]

I'm trying to create a timesheet form for several users. I
have tabels: Emp, Mgr, Dept#, WeekEnding, and FT/PT.
Ideally, I'd like to be able to have a user select their
Dept# from a combobox on the form and have their Manager's
(Mgr) name also in a combobox?, with a list of all the
employees under that particular Dept#.
i.e.
Mgr - Barb
Dept - BS1 and BS2
Mgr - Peggy
Dept - PE1, PE2 and PE3 and so on.
Each Mgr has several Dept#'s. How can I show that Barb is
responsible for only these 2 departments and Peggy...etc?

I'm stumped - Kelly

 

[Pavel Romashkin]

I observed that this question is by far the most frequently asked on on
the NG. I think what you are looking for is "cascading combo boxes", and
you can find answers here

http://groups.google.com/groups?hl=...o+boxes&meta=group%3Dcomp.databases.ms-access

In short, you want to use SQL that returns the list of names for
RowSource of the first combo box, and you want to use the first combo
box as a parameter in the WHERE clause of the SQL used as a RowSource in
the second combo box.
Good luck,
Pavel