Linking lists and controls together

[Arty]

Hi all!!

I need help on linking two look-up fields together.

You know when you complete registration forms on the web
you often have a City field, which changes its look-up
values when you change the value of the country field?

I want to have the same thing in my database (when
entering data through a form) but I don't know how to do
it. Searched through office knowledge base, office online
help and, of course, office Access help itself. Didn't
find anything.

Please, help!!

Arty

 

[John Vinson]

Hi all!!

I need help on linking two look-up fields together.

You know when you complete registration forms on the web
you often have a City field, which changes its look-up
values when you change the value of the country field?

I want to have the same thing in my database (when
entering data through a form) but I don't know how to do
it. Searched through office knowledge base, office online
help and, of course, office Access help itself. Didn't
find anything.

Try the code at http://www.mvps.org/access/forms/frm0028.htm