lookup list and getting values from one to define another

[Jaylynn]

I need in my database to create a list that will, in turn, affect the choices in another list.
An example will explain better
If I choose a state from one list that has been defined to hold only the 50 states, I would like another list to show only the counties within the designated state.
Is it possible to do this
Thank you for your help
Jaylynn

 

[John Vinson]

I need in my database to create a list that will, in turn, affect the choices in another list.
An example will explain better,
If I choose a state from one list that has been defined to hold only the 50 states, I would like another list to show only the counties within the designated state.
Is it possible to do this?
Thank you for your help,
Jaylynn

It is: see http://www.mvps.org/access/forms/frm0028.htm