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
> Since a listbox has a RowSource property just like a Combobox, I would
> expect it to work just the same.
[quoted text clipped - 25 lines]
> > 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
MacDermott - 27 May 2005 23:32 GMT
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.
> sorry, i am a new user - so sometimes there are several things in error at
> the same time...
[quoted text clipped - 37 lines]
> > > 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