Listbox 'list' based on another

[alex]

Hello All,

Using Access 03’…

I’m wondering if anyone has experienced the following:

I have form with about 5 listboxes; each listbox value feeds a
corresponding textbox on a subform.

The listboxes are all visible from left to right; e.g., lst1, lst2,
lst3, lst4, lst5.

The value options (what’s available) in lst5 are based on what’s
selected in lst4.
The value options (what’s available) in lst4 are based on what’s
selected in lst3.
The value options (what’s available) in lst3 are based on what’s
selected in lst2…etc.

To put it another way; I select a value in lst1. Based on my
selection, lst2 populates with certain values. I then select a value
in lst2. Based on my selection, lst3 populates with certain values.

What I described above works great; it wasn’t too difficult to
configure!

What I’d like to do, however, is find a way to link all listboxes
together. I.e.,:

The value options (what’s available) in lst5 are not only based on
what’s selected in lst4, but what’s selected in lst3, lst2, and lst1.

I actually found a way to do this (I created one table) but it was >
15,000 records!—too big to manage.

I’m inquiring if anyone has built something like this, or has advice
on how to simplify it.

Thanks,
alex

 

[Al Campagna]

Alex,
If your using the value of the previous listbox to filter the current
listbox (and etc.)...
you're actually doing that.

The value options (what’s available) in lst5 are not only based on
what’s selected in lst4, but what’s selected in lst3, lst2, and lst1.

Example: three listboxes (lst1, lst2, lst3) for Country, State, and
City.
Say you select USA, Texas, Dallas...
Dallas is in the USA (not any other country)
Dallas is in Texas (not any other state)
The value options inlst 3 is based on what's in lst1... as well
as wht's in lst2.
--
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."


Hello All,

Using Access 03’…

I’m wondering if anyone has experienced the following:

I have form with about 5 listboxes; each listbox value feeds a
corresponding textbox on a subform.

The listboxes are all visible from left to right; e.g., lst1, lst2,
lst3, lst4, lst5.

The value options (what’s available) in lst5 are based on what’s
selected in lst4.
The value options (what’s available) in lst4 are based on what’s
selected in lst3.
The value options (what’s available) in lst3 are based on what’s
selected in lst2…etc.

To put it another way; I select a value in lst1. Based on my
selection, lst2 populates with certain values. I then select a value
in lst2. Based on my selection, lst3 populates with certain values.

What I described above works great; it wasn’t too difficult to
configure!

What I’d like to do, however, is find a way to link all listboxes
together. I.e.,:

The value options (what’s available) in lst5 are not only based on
what’s selected in lst4, but what’s selected in lst3, lst2, and lst1.

I actually found a way to do this (I created one table) but it was >
15,000 records!—too big to manage.

I’m inquiring if anyone has built something like this, or has advice
on how to simplify it.

Thanks,
alex

 

[alex]

Alex,
    If your using the value of the previous listbox to filter the current
listbox (and etc.)...
you're actually doing that.


    Example: three listboxes (lst1, lst2, lst3) for Country, State, and
City.
    Say you select USA, Texas, Dallas...
        Dallas is in the USA (not any other country)
        Dallas is in Texas (not any other state)
    The value options inlst 3 is based on what's in lst1... as well
as wht's in lst2.
--
    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."


Hello All,

Using Access 03’…

I’m wondering if anyone has experienced the following:

I have form with about 5 listboxes; each listbox value feeds a
corresponding textbox on a subform.

The listboxes are all visible from left to right; e.g., lst1, lst2,
lst3, lst4, lst5.

The value options (what’s available) in lst5 are based on what’s
selected in lst4.
The value options (what’s available) in lst4 are based on what’s
selected in lst3.
The value options (what’s available) in lst3 are based on what’s
selected in lst2…etc.

To put it another way; I select a value in lst1.  Based on my
selection, lst2 populates with certain values.  I then select a value
in lst2.  Based on my selection, lst3 populates with certain values.

What I described above works great; it wasn’t too difficult to
configure!

What I’d like to do, however, is find a way to link all listboxes
together.  I.e.,:

The value options (what’s available) in lst5 are not only based on
what’s selected in lst4, but what’s selected in lst3, lst2, and lst1.

I actually found a way to do this (I created one table) but it was >
15,000 records!—too big to manage.

I’m inquiring if anyone has built something like this, or has advice
on how to simplify it.

Thanks,
alex

Al, thanks for responding…my listboxes, however, are a bit more
arbitrary than country, state, and city.

For example, lst5 contains actions (e.g., file, data entry, audit,
research, etc.).
Lst4 contains things that actions are performed on (e.g., letter, e-
mail, speech, dictation, etc.).
Lst3 contains where the ‘things’ come from (e.g., public, internal,
exec, floor, etc.).

If I select “internal” in lst3, then letter, e-mail, and speech are
available in lst4.
I then select “e-mail” in lst4 and file, data entry, and audit are
available in lst5.

The problem (as an example) is that audit, while a legitimate choice
under e-mail does not come from an “internal” source (it comes from
other sources), so it technically should not be available. It gets a
little complicated. As I mentioned before, I created a table with
every conceivable option…it was 15,000 + records!

I thought that someone may have a clever way to deal with this issue.

alex

 

[Al Campagna]

Alex,
You wrote...

To put it another way; I select a value in lst1. Based on my
selection, lst2 populates with certain values. I then select a value
in lst2. Based on my selection, lst3 populates with certain values.

This is referred to as Cascading Listboxes. Each list is filtered
by ALL the previous list selections. The user makes selections in
sequential order
(in your case lst1 to lst5).
lst1 value is selected...
lst2 is filtered by lst1
lst3 is filtered by lst2
lst4 is filtered by lst3
lst5 is filtered by lst4

Then, *logically*, the selections available in lst5 have been limited by
ALL the previous list selections...
not just lst4.

I can't think of any other way to put it.
Apologies if I still don't get what you're trying to do.

Someone else may jump in on this issue, but if not...
reply to this thread, stating that you are starting a new post, and
resubmit your question as such.
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."

Alex,
If your using the value of the previous listbox to filter the current
listbox (and etc.)...
you're actually doing that.


Example: three listboxes (lst1, lst2, lst3) for Country, State, and
City.
Say you select USA, Texas, Dallas...
Dallas is in the USA (not any other country)
Dallas is in Texas (not any other state)
The value options inlst 3 is based on what's in lst1... as well
as wht's in lst2.
--
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."


Hello All,

Using Access 03’…

I’m wondering if anyone has experienced the following:

I have form with about 5 listboxes; each listbox value feeds a
corresponding textbox on a subform.

The listboxes are all visible from left to right; e.g., lst1, lst2,
lst3, lst4, lst5.

The value options (what’s available) in lst5 are based on what’s
selected in lst4.
The value options (what’s available) in lst4 are based on what’s
selected in lst3.
The value options (what’s available) in lst3 are based on what’s
selected in lst2…etc.

To put it another way; I select a value in lst1. Based on my
selection, lst2 populates with certain values. I then select a value
in lst2. Based on my selection, lst3 populates with certain values.

What I described above works great; it wasn’t too difficult to
configure!

What I’d like to do, however, is find a way to link all listboxes
together. I.e.,:

The value options (what’s available) in lst5 are not only based on
what’s selected in lst4, but what’s selected in lst3, lst2, and lst1.

I actually found a way to do this (I created one table) but it was >
15,000 records!—too big to manage.

I’m inquiring if anyone has built something like this, or has advice
on how to simplify it.

Thanks,
alex

Al, thanks for responding…my listboxes, however, are a bit more
arbitrary than country, state, and city.

For example, lst5 contains actions (e.g., file, data entry, audit,
research, etc.).
Lst4 contains things that actions are performed on (e.g., letter, e-
mail, speech, dictation, etc.).
Lst3 contains where the ‘things’ come from (e.g., public, internal,
exec, floor, etc.).

If I select “internal” in lst3, then letter, e-mail, and speech are
available in lst4.
I then select “e-mail” in lst4 and file, data entry, and audit are
available in lst5.

The problem (as an example) is that audit, while a legitimate choice
under e-mail does not come from an “internal” source (it comes from
other sources), so it technically should not be available. It gets a
little complicated. As I mentioned before, I created a table with
every conceivable option…it was 15,000 + records!

I thought that someone may have a clever way to deal with this issue.

alex