How do I link a list to the previous list answer in an Access For.

[Guest]

I'm trying to set up a form in access. I want to link an answer from one
list to the options available in the next list. For instance, the first list
shows available accounts. The second list shows available projects under the
selected account. I can not figure out how to do this.

 

[John Vinson]

I'm trying to set up a form in access. I want to link an answer from one
list to the options available in the next list. For instance, the first list
shows available accounts. The second list shows available projects under the
selected account. I can not figure out how to do this.

There's sample code at the Access Web: Try the second suggestion at

http://www.mvps.org/access/forms/frm0028.htm


John W. Vinson[MVP]