limiting list box selections

[RNicole]

I am building a table with several list boxes. When entering a record, I
want the user's selection in one list box to effect the choices in another
list box.

How do a create a list box that displays particular values based on another
list box

 

[Jerry Whittle]

First off you can't do it in a table or query. You'll need to do it in a form.

Roger Carlson has an example of cascading combo boxes in his library:
http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=389