Multiple list boxes

[ANDY-N]

In my form design, I have 3 list boxes in a form. List box 1 is created from
a query, and is unbound. List box 2 is set to get whatever I selected from
box 1. These two boxes work, without problems. Now I run into troubles trying
to get list box 3 to get information from what I selected from list box 2.
The criteria for list box 3 is [forms]![formname]![listbox2]...please help.
Thank you.

 

[Al Campagna]

Andy,
What happens with List3? Do you get too many records, too few, wrong
records, etc...?
Please indicate sample values, and your filtering fields and criteria
from List1 through List3.
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

 

[ANDY-N]

Al-

List 3 did not return anything. For instance list1 has indirect hour type and
total indirect hours, list 2 has indirect hour type, department name, and
indirect hour. List 3 has indirect hour type, department, employee name and
indirect hour. I was trying to link all three together, list1 and list2 link
by indirect hour type, and list2 and list3 will be linked by indirect hour
type and department.

List2 criteria: indirect hour type: [forms]![formname]![list1]
List3 criteria: indirect hour type: [forms]![formname]![list2]; department:
[forms]![formname]![list2]

Andy,
What happens with List3? Do you get too many records, too few, wrong
records, etc...?
Please indicate sample values, and your filtering fields and criteria
from List1 through List3.

In my form design, I have 3 list boxes in a form. List box 1 is created
from

[quoted text clipped - 5 lines]

help.
Thank you.

 

[ANDY-N]

UPDATE

I got all the list boxes to work together now. Thank you for the help!

Al-

List 3 did not return anything. For instance list1 has indirect hour type and
total indirect hours, list 2 has indirect hour type, department name, and
indirect hour. List 3 has indirect hour type, department, employee name and
indirect hour. I was trying to link all three together, list1 and list2 link
by indirect hour type, and list2 and list3 will be linked by indirect hour
type and department.

List2 criteria: indirect hour type: [forms]![formname]![list1]
List3 criteria: indirect hour type: [forms]![formname]![list2]; department:
[forms]![formname]![list2]

Andy,
What happens with List3? Do you get too many records, too few, wrong

[quoted text clipped - 6 lines]

 

[Al Campagna]

Andy,
I can't tell what List2 is bound to, so I'll assume it delivers a
Department value..
If List2 is "bound" to Department (the value that is stored in List2) and
it is used as the criteria for Department in List3, then it's bound value
can not also provide the criteria value for IndirectHourType too.. That
information is probably not in the "bound colum" of the listbox, but in
another.
Your calling the same value for both criteria...

Listbox colums are numbered 0,1,2,3,... etc.
Try... just an example using List2 column 2 as the IndirectHourColumn...

List 3 criteria:
Department = [forms]![formname]![list2]
IndirectHourType = [forms]![formname]![list2].column(2)
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

Al-

List 3 did not return anything. For instance list1 has indirect hour type
and
total indirect hours, list 2 has indirect hour type, department name, and
indirect hour. List 3 has indirect hour type, department, employee name
and
indirect hour. I was trying to link all three together, list1 and list2
link
by indirect hour type, and list2 and list3 will be linked by indirect hour
type and department.

List2 criteria: indirect hour type: [forms]![formname]![list1]
List3 criteria: indirect hour type: [forms]![formname]![list2];
department:
[forms]![formname]![list2]

Andy,
What happens with List3? Do you get too many records, too few, wrong
records, etc...?
Please indicate sample values, and your filtering fields and criteria
from List1 through List3.

In my form design, I have 3 list boxes in a form. List box 1 is created
from

[quoted text clipped - 5 lines]

help.
Thank you.

 

[ANDY-N via AccessMonster.com]

Thanks Al, you're right, I was calling up the same value and should have
pointed to another column. I used a concatenated key and it did what I wanted
it to do. Thanks for the replies.

Andy,
I can't tell what List2 is bound to, so I'll assume it delivers a
Department value..
If List2 is "bound" to Department (the value that is stored in List2) and
it is used as the criteria for Department in List3, then it's bound value
can not also provide the criteria value for IndirectHourType too.. That
information is probably not in the "bound colum" of the listbox, but in
another.
Your calling the same value for both criteria...

Listbox colums are numbered 0,1,2,3,... etc.
Try... just an example using List2 column 2 as the IndirectHourColumn...

List 3 criteria:
Department = [forms]![formname]![list2]
IndirectHourType = [forms]![formname]![list2].column(2)

Al-

[quoted text clipped - 23 lines]