Determining items in a listbox based on selection of combo box

r3df1sh

Registered User.
Local time
Yesterday, 19:34
Joined
Sep 8, 2004
Messages
16
I need some more guidance. I have a form that contains a listbox. The listbox populates from a table (multiple fields). I would like to add a combobox on the form, that, given it's choice will show only those entries.

Combobox Options: All (shows All), Location1 (Shows Only Location1), etc...

Any guidance is greatly appreciated.
Thanks in advance.
 
Last edited:
Search here for examples of cascading combo boxes, the principle's the same for a list box
 
It might be the newbishness, but I have looked throughout several examples and am still lost.

Perhaps I can explain my attempt better:
On my form Frm_IPList I have cb_iplist list box.
(The displayed contents of this form are 7 fields in my tbl_iplist table.)

Right now it simply pulls all of the data in those fields.

I am wanting to Add a combobox that, based on the value selected, will only show those entries in the table matching that value. (I am looking to have a view all records and display specific locations).

I am also wanting to add a text box that will allow a similar function based on the value entered against a specific collumn in the list box.

Sorry I am a blind man in the Access world.
 

Users who are viewing this thread

Back
Top Bottom