filtering a list box using a filtered combo box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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?
 
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
 
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.
 
Back
Top