Combo Box effected by other box

B

Brian

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
 
Top