Determining the values in one list based on another

[bellis]

Hello,

I'm new to Access and having trouble with some (I would assume) basics.

I have a table with a few Listbox options. I want one of the columns' values to be determined by the value chosen in another field. How do I do this?

Example: In column A I choose value ABC from the dropdown. I want column B to now offer values in that list of DEF, GHI, JKL. If I chose XYZ in column A instead, I'd want the column B list to show MNO, PQR, STU. Etc.

Thanks!

 

[Mr. B]

From your post it would appear that you are attempting to do this in your table. Something like what you are wanting to do should be done in a form not in the table. What you are wanting to do is called "cascading" combo or list boxes.

There are several threads and examples on the forum that explain how to create and use cascading combo or list boxes.

 

[boblarson]

This is for a combo box but, as Mr. B wrote, it will work with a listbox too (as long as the first listbox is only single select):
http://www.baldyweb.com/CascadingCombo.htm

 

[bellis]

Thanks! Already a huge help!

Do I need separate tables for my data? ie a NY table with cities in NY, a NJ table with cities in NJ, etc. Or can they all be in the same and referenced via a column title?

 

[boblarson]

Single table with City and State fields.

 

[bellis]

Thanks this worked like a charm!

I'm having one problem still with the Requery portion. What is "Me."? Should that reference something in my file? Its not refreshing after the update.

 

[cms2012]

The me. is referencing the form that you are using. So say if you had a state and a city combo box, to requery the city box after a state had been selected you would do Requery Me.combocity