If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
filtering a list box using a filtered combo box
been reading ms access 2003 inside out, and from it, i've learned how to use
a combo box to filter another combo box my question is, what if i want to use this filtered combo box to filter a list box? - and if that is impossible, is there another way to set this problem up so that the user can choose from list A and have that choice limit the options on list B, the choice from which in turn limits the user options in list C? for context, the options in list A (cases) are in a one-to-many relationship with the options in list C (depositions), and the options in list B (attorneys) are in many-to-many relationships with A and C - for the purposes of the form, the user will only ever need to choose one option from list A and one option from list B per use of the form, but may need to choose more than one option at a time from list C thanks in advance for any insight - i've been banging my head on this problem for a solid week and could use any information at all |
#2
|
|||
|
|||
Since a listbox has a RowSource property just like a Combobox, I would
expect it to work just the same. Would you like to say something about the differences/problems you have encountered? "davidchadwick" wrote in message ... been reading ms access 2003 inside out, and from it, i've learned how to use a combo box to filter another combo box my question is, what if i want to use this filtered combo box to filter a list box? - and if that is impossible, is there another way to set this problem up so that the user can choose from list A and have that choice limit the options on list B, the choice from which in turn limits the user options in list C? for context, the options in list A (cases) are in a one-to-many relationship with the options in list C (depositions), and the options in list B (attorneys) are in many-to-many relationships with A and C - for the purposes of the form, the user will only ever need to choose one option from list A and one option from list B per use of the form, but may need to choose more than one option at a time from list C thanks in advance for any insight - i've been banging my head on this problem for a solid week and could use any information at all |
#3
|
|||
|
|||
sorry, i am a new user - so sometimes there are several things in error at
the same time... my question was not so much about differences between list boxes and combo boxes - it is more in regards to the "middle" combo box - the one that is both filtered by combo box "A" and a filter for list box "C" - does this combo box B need to be unbound so as to properly filter list box C, or does it need to be bound so as to properly accept the filtration of combo box A, or both, or neither? thanks for your patience "MacDermott" wrote: Since a listbox has a RowSource property just like a Combobox, I would expect it to work just the same. Would you like to say something about the differences/problems you have encountered? "davidchadwick" wrote in message ... been reading ms access 2003 inside out, and from it, i've learned how to use a combo box to filter another combo box my question is, what if i want to use this filtered combo box to filter a list box? - and if that is impossible, is there another way to set this problem up so that the user can choose from list A and have that choice limit the options on list B, the choice from which in turn limits the user options in list C? for context, the options in list A (cases) are in a one-to-many relationship with the options in list C (depositions), and the options in list B (attorneys) are in many-to-many relationships with A and C - for the purposes of the form, the user will only ever need to choose one option from list A and one option from list B per use of the form, but may need to choose more than one option at a time from list C thanks in advance for any insight - i've been banging my head on this problem for a solid week and could use any information at all |
#4
|
|||
|
|||
OK, I think there are two different sets of data we're talking about here.
Any combobox or listbox has a RowSource, which determines what values show up in the drop-down list. This list can be filtered by a reference to the choice made in a previous combo (or list) box. In addition, the value chosen in a combo (or single-select list) box can be stored in a field in the record underlying the table it's on. This is done by setting the ControlSource of the control, and is commonly called "binding" the control. You may wish to note that a multiselect listbox cannot be bound. (You can't store multiple values in one field.) If this isn't enough explanation to help you work out your issue, please try rephrasing your question and post again. "davidchadwick" wrote in message ... sorry, i am a new user - so sometimes there are several things in error at the same time... my question was not so much about differences between list boxes and combo boxes - it is more in regards to the "middle" combo box - the one that is both filtered by combo box "A" and a filter for list box "C" - does this combo box B need to be unbound so as to properly filter list box C, or does it need to be bound so as to properly accept the filtration of combo box A, or both, or neither? thanks for your patience "MacDermott" wrote: Since a listbox has a RowSource property just like a Combobox, I would expect it to work just the same. Would you like to say something about the differences/problems you have encountered? "davidchadwick" wrote in message ... been reading ms access 2003 inside out, and from it, i've learned how to use a combo box to filter another combo box my question is, what if i want to use this filtered combo box to filter a list box? - and if that is impossible, is there another way to set this problem up so that the user can choose from list A and have that choice limit the options on list B, the choice from which in turn limits the user options in list C? for context, the options in list A (cases) are in a one-to-many relationship with the options in list C (depositions), and the options in list B (attorneys) are in many-to-many relationships with A and C - for the purposes of the form, the user will only ever need to choose one option from list A and one option from list B per use of the form, but may need to choose more than one option at a time from list C thanks in advance for any insight - i've been banging my head on this problem for a solid week and could use any information at all |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Limit combo box list only | Bruce | Using Forms | 4 | December 22nd, 2004 05:07 PM |
Combo Box Problem | Mr. T | New Users | 15 | July 15th, 2004 09:47 PM |
Filtering Records using multiple combo boxes | Mark Senibaldi | Using Forms | 0 | June 17th, 2004 03:51 PM |
Formulas employing cells linked to a combo box drop list | Frank Kabel | Worksheet Functions | 3 | May 27th, 2004 04:44 PM |
How do you create a list in a Combo or List Box? | Bob Phillips | Worksheet Functions | 1 | February 16th, 2004 09:06 PM |