Hi,
On my form I have one field of "City", and this in turn needs to
effect "Township". When township is selected, the next field is
distance, and for every 'township' there are 2 distances available to
pick. (i.e. Washington brings townships 1-5, then township #1 has
distances of 23Miles or 36Miles). How do I:
1) Make sure when a city is selected, only the townships in that city
show up in the next drop down box.
2) Once a township is selected, there are basically 2 options in the
next drop down box that should show up.
What's the best way to do this?
Thanks much!!
Jana - 12 Apr 2006 22:39 GMT
Howdy:
Try searching for 'Synchronize Combo Boxes' in the Microsoft Knowledge
Base. The article is different, depending on the version of Access
you're using:
'97 or earlier: http://support.microsoft.com/kb/98660/en-us
2000: http://support.microsoft.com/kb/209595/en-us
2002 or 2003: http://support.microsoft.com/kb/289670/en-us
HTH,
Jana
pietlinden@hotmail.com - 13 Apr 2006 01:01 GMT
http://www.mvps.org/access/forms/frm0028.htm