Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / New Users / May 2005

Tip: Looking for answers? Try searching our database.

filtering a list box using a filtered combo box

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
davidchadwick - 26 May 2005 19:10 GMT
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
MacDermott - 27 May 2005 03:29 GMT
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?

> been reading ms access 2003 inside out, and from it, i've learned how to use
> a combo box to filter another combo box
[quoted text clipped - 14 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
davidchadwick - 27 May 2005 14:12 GMT
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
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.