By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,871 Members | 2,444 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,871 IT Pros & Developers. It's quick & easy.

Making combo boxes change options in other combo boxes

P: n/a
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!!

Apr 12 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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

Apr 12 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.