can i have the data in a combo box selected by tow other combo bo.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i have a question.
i have 3 combo boxes.
the 2nd`s content is decideed by the first`s selection. i use a query for
that.
in the 3rd one, i want to have something like this:
- i`m making a selection in thethe first combo box. but i don`t select
nothing in the second one. in the 3rd combo box, i`l have a list that is
decided by the selection in the 1st.
- i`m making a selection in the 1st and 2nd combo box. in the 3rd one i`ll
have a list decided by the selection in the 2nd.
if this is possible, i would like to know, and i`ll definitelly need help.
 
i have a question.
i have 3 combo boxes.
the 2nd`s content is decideed by the first`s selection. i use a query for
that.
in the 3rd one, i want to have something like this:
- i`m making a selection in thethe first combo box. but i don`t select
nothing in the second one. in the 3rd combo box, i`l have a list that is
decided by the selection in the 1st.
- i`m making a selection in the 1st and 2nd combo box. in the 3rd one i`ll
have a list decided by the selection in the 2nd.
if this is possible, i would like to know, and i`ll definitelly need help.
Click to expand...

It's possible; it requires a bit of VBA code. Could you post the
RowSources and (if those are tables) the relevant fields of the three
combo boxes? Also indicate the logic - how do the first two combos
interact with one another and with the third.

Essentially what you'll want to do is write VBA code to reassign the
RowSource of the third combo box in the afterupdate events of the
other two combos.

John W. Vinson[MVP]
 
I`ll try to be a little more specific.
I have several departaments, in which diferent people have diferent jobs.
the first combo box is the selection of the departament.
the second one selects the job, and the third one, are the employees.

what i want to do, is something like this:
1st -> 2nd -> 3rd or
1st -> 3rd.

I`ll explain.

the first combo box gives us the jobs, and the jobs gives us the people.
But, in some cases i don`t need to select a job, so, what i want to do is,
that if I don`t select a job, in the third combo box, i would have all the
people in the departament selected in the first combo.

The problem is, that i can make the selection, in VBA, but i don`t know how
to do it for 2 critereas.
the first case: 1st -> 2nd -> 3rd, i did it, but i don`t know how to do this
thing: if a don`t select a job, i want all the people in the departament.
 
Back
Top