Combo Box effected by other box

[Guest]

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!!

-Brian

 

[Van T. Dinh]

See The Access Web article:

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

 

[RobFMS]

Just as a point of reference, for those that may look at this posting later,
there is an "issue" when you use continuous form/datasheet.

Tip #16: Data in a combo box control on a continuous form/datasheet
disappears
http://www.fmsinc.com/free/tips.html#tip16foraccess

--
Rob Mastrostefano

FMS Professional Solutions Group
http://www.fmsinc.com/consulting

Software Tools for .NET, SQL Server, Visual Basic & Access
http://www.fmsinc.com