Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / General 1 / April 2006

Tip: Looking for answers? Try searching our database.

Making combo boxes change options in other combo boxes

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
bmdavis - 12 Apr 2006 17:51 GMT
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
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.