G
Guest
I have a list box that I would like to populate with selections based on 2
other multiselect list booxes. I am not sure as to the best way to do this.
Below is a summary of what I have so far:
Currently I have a list box (lst1) getting its data based on the selection
of one other multiselect list box (lst2). This is done by appending data to a
seperate table once a selection is chosen in lst2 and using this data as
lst1's record source. Unfortunately I have not been able to use this logic
to encompass adding one more multiselect list box as a criteria identifier
for lst 1. I have tried using an imbedded For...Each loop but it will only
let me use one at a time.
Is the approach I am using the best way? If not, does anyone think they can
offer advice?
This would be greatly appreciated,
Chad Lucy
other multiselect list booxes. I am not sure as to the best way to do this.
Below is a summary of what I have so far:
Currently I have a list box (lst1) getting its data based on the selection
of one other multiselect list box (lst2). This is done by appending data to a
seperate table once a selection is chosen in lst2 and using this data as
lst1's record source. Unfortunately I have not been able to use this logic
to encompass adding one more multiselect list box as a criteria identifier
for lst 1. I have tried using an imbedded For...Each loop but it will only
let me use one at a time.
Is the approach I am using the best way? If not, does anyone think they can
offer advice?
This would be greatly appreciated,
Chad Lucy