Creating a hierarchical search on a single form

[John Reid]

G'day,

is it possible to have a form with 3 list boxes that
performs a cascading search. The first list box shows the
top level list, the second level takes the item selected
from the first list and displays a drilled down list. The
third list box takes the item selected in the second list
and usses it to produce a drilled down list. Are there any
examples that i could be pointed to
the form is based on three tables that correspond to each
list box

salud

John

 

[tina]

-----Original Message-----
G'day,

is it possible to have a form with 3 list boxes that
performs a cascading search. The first list box shows the
top level list, the second level takes the item selected
from the first list and displays a drilled down list. The
third list box takes the item selected in the second list
and usses it to produce a drilled down list. Are there any
examples that i could be pointed to
the form is based on three tables that correspond to each
list box

salud

John
.

are the tables linked? if so, yes it can be done fairly
easily. i'll use as my example
ListBox1 - Companies
ListBox2 - Departments
ListBox3 - Employees

set ListBox2 RowSource to include a WHERE clause, as
[Dept_Company] = Forms!FormName!ListBox1
set a macro or procedure on the AfterUpdate event of
ListBox1, to Requery ListBox2.

set ListBox3 RowSource to include a WHERE clase, as
[Employee_Dept] = Forms!FormName!ListBox2
set a macro or procedure on the AfterUpdate event of
ListBox2, to Requery ListBox3.

 

[John Reid]

thanx Tina,

neat

i am working my way thru it

salud

John

-----Original Message-----
G'day,

is it possible to have a form with 3 list boxes that
performs a cascading search. The first list box shows the
top level list, the second level takes the item selected
from the first list and displays a drilled down list. The
third list box takes the item selected in the second list
and usses it to produce a drilled down list. Are there any
examples that i could be pointed to
the form is based on three tables that correspond to each
list box

salud

John
.

are the tables linked? if so, yes it can be done fairly
easily. i'll use as my example
ListBox1 - Companies
ListBox2 - Departments
ListBox3 - Employees

set ListBox2 RowSource to include a WHERE clause, as
[Dept_Company] = Forms!FormName!ListBox1
set a macro or procedure on the AfterUpdate event of
ListBox1, to Requery ListBox2.

set ListBox3 RowSource to include a WHERE clase, as
[Employee_Dept] = Forms!FormName!ListBox2
set a macro or procedure on the AfterUpdate event of
ListBox2, to Requery ListBox3.

 

[John Reid]

i have got it half to work, but the second list box does not retain the item
selected and the third list box comes up empty.

i do not understand why the third box would come up empty. i have made a
mistake somewhere, any thoughts?

salud

John

-----Original Message-----
G'day,

is it possible to have a form with 3 list boxes that
performs a cascading search. The first list box shows the
top level list, the second level takes the item selected
from the first list and displays a drilled down list. The
third list box takes the item selected in the second list
and usses it to produce a drilled down list. Are there any
examples that i could be pointed to
the form is based on three tables that correspond to each
list box

salud

John
.

are the tables linked? if so, yes it can be done fairly
easily. i'll use as my example
ListBox1 - Companies
ListBox2 - Departments
ListBox3 - Employees

set ListBox2 RowSource to include a WHERE clause, as
[Dept_Company] = Forms!FormName!ListBox1
set a macro or procedure on the AfterUpdate event of
ListBox1, to Requery ListBox2.

set ListBox3 RowSource to include a WHERE clase, as
[Employee_Dept] = Forms!FormName!ListBox2
set a macro or procedure on the AfterUpdate event of
ListBox2, to Requery ListBox3.