Getting a combo box to auto fill next text box?

[Mksmall]

On a form I have a combo box that lists counties. My next box list townships that are in the listed counties. Is there a way to limit the list you see in the 2nd box to only show you what townships are in the county that you selected from the first box? What I am trying to accomplish is if someone picks "Jackson" from drop down box one, then when they click on drop down box 2..all that they see are those townships for Jackson county.

 

[PaulBricker]

In the AfterUpdate Event for Combo1 you would put something like this
Dim strSQL as String
strSQL = "Select TableName.Townships From TableName Where TableName.County = '" & Forms!YourForm!Combo1 & "'"
Me.Combo2.RowSource = strSQL

That should get you close

Paul

 

[gusbrunston]

Hi:

There is an FAQ on this forum that describes this. (By an expert, Rick Spring.)

Heres the FAQ thread: faq702-681 Gus Brunston An old PICKer, using Access2000.