Multiple list boxes!

[tha-liner]

Is it possible to control the options available in one list box with an option made from a previous listbox? If so how do I do this?

Thanks

 

[TanisAgain]

Do a search for cascading combobox.

 

[tha-liner]

found it! THANKS!!

however, now how would I be able to have a list box that affects a box with no possible options.

For example as in the cascading list demo!

A list box with all the cities from all the countries, and a second box that automatically puts in which country that city is from?

thanks in advance

 

[supercharge]

found it! THANKS!!
...
A list box with all the cities from all the countries, and a second box that automatically puts in which country that city is from?
...

Add a DLookup to your listbox's afterupdate sub.

Example: (just brainstorming, check for syntax, Country table has two fields: Country and City)

Private sub listbox_afterupdate()
    CountryListBox = DLookup("[Country]","CountryTable","[City] = listbox.value")
End Sub

 

[neileg]

found it! THANKS!!

however, now how would I be able to have a list box that affects a box with no possible options.

For example as in the cascading list demo!

A list box with all the cities from all the countries, and a second box that automatically puts in which country that city is from?

thanks in advance

Why not have a two column combo that lists city and country?

 

[tha-liner]

thanks a lot again...i'm really just learning access and i really appreciate the info.

i really want an auto complete box. let me give the exact example. it is a complaints database...where customers call and give problems with a particular product. these problems are in categories...when a complaint is received (cboproblem) i want that specific problem to be automatically placed into categories shown by the textbox (txtclass). i have 1 table (tblnamecompl) which has 2 columns Problem & Classification.