conditional list box

[RNicole]

I am building a table with several list boxes. When entering a record, I
want the user's selection in one list box to effect the choices in another
list box.

How do a create a list box that displays particular values based on another
list box

 

[Dorian]

Listboxes are in a form not in a table.
You will have to refresh the listbox row source in response to any update in
the other listbox. e.g.
Me!Listbox.RowSource = "....."
Me!Listbox.Requery
You will have to cater for the case where a selection in one listbox is
nullified because that value is no longer valid.
-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".

 

[RNicole]

Thanks but Access 2007 does have list boxes in the tables (at least that is
what they are referred to in the application)

 

[Jeff Boyce]

I suspect you are referring to the much-maligned "lookup" data type, that
provides comboboxes (not listboxes) in tables.

No, there is no way to have, at the table level, one lookup field limit
another. That's what "cascading comboboxes" in forms are for.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Jeff Boyce]

Posting the same issue repeated, and in different newsgroups, is frowned on.
Not only do you have to look in multiple places to see if you've received an
answer, doing so causes multiple folks to treat your question as if it
hadn't been answered and spend time working on it. Since we're all
volunteers here, it ends up costing both you and us more time...

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Andy Buissereth]

You said that it can't be done at the table level. Can it be done with forms. If not, then how do you make the cascading combobox display a certain list of options based off of selection the user makes in a previous field?



Jeff Boyce wrote:

I suspect you are referring to the much-maligned "lookup" data type, that
21-Sep-09

I suspect you are referring to the much-maligned "lookup" data type, tha
provides comboboxes (not listboxes) in tables

No, there is no way to have, at the table level, one lookup field limi
another. That's what "cascading comboboxes" in forms are for

Regard

Jeff Boyc
Microsoft Office/Access MVP

Previous Posts In This Thread:

conditional list box
I am building a table with several list boxes. When entering a record,
want the user's selection in one list box to effect the choices in anothe
list box

How do a create a list box that displays particular values based on anothe
list box

Listboxes are in a form not in a table.
Listboxes are in a form not in a table
You will have to refresh the listbox row source in response to any update i
the other listbox. e.g
Me!Listbox.RowSource = ".....
Me!Listbox.Requer
You will have to cater for the case where a selection in one listbox i
nullified because that value is no longer valid
-- Doria
"Give someone a fish and they eat for a day; teach someone to fish and the
eat for a lifetime"

:

Thanks but Access 2007 does have list boxes in the tables (at least that is
Thanks but Access 2007 does have list boxes in the tables (at least that i
what they are referred to in the application

:

I suspect you are referring to the much-maligned "lookup" data type, that
I suspect you are referring to the much-maligned "lookup" data type, tha
provides comboboxes (not listboxes) in tables

No, there is no way to have, at the table level, one lookup field limi
another. That's what "cascading comboboxes" in forms are for

Regard

Jeff Boyc
Microsoft Office/Access MVP

Posting the same issue repeated, and in different newsgroups, is frowned on.
Posting the same issue repeated, and in different newsgroups, is frowned on
Not only do you have to look in multiple places to see if you have received a
answer, doing so causes multiple folks to treat your question as if i
had not been answered and spend time working on it. Since we are al
volunteers here, it ends up costing both you and us more time..

Regard

Jeff Boyc
Microsoft Office/Access MVP


Submitted via EggHeadCafe - Software Developer Portal of Choice
A Good Solution for "Magic String" Data
http://www.eggheadcafe.com/tutorial...f3-aa98ed6669c3/a-good-solution-for-magi.aspx

 

[John Spencer]

This link describes two methods on using/setting up cascading comboboxes:

http://www.mvps.org/access/forms/frm0028.htm

Post back if you need help.

Additional References:
http://www.comeandread.com/access/tip016.htm

Check out this article for a detailed discussion.
http://www.fontstuff.com/access/acctut08.htm

Or check out this from MS
http://office.microsoft.com/en-us/access/HA011730581033.aspx

John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County